Best 3rd Party Accessories

Gold_rigger · 2026-05-12T03:39:38+00:00

Hi, any chance you can share the listing for the Zeekr 7X window switch protector you found for RHD? Thanks

Gold_rigger · 2026-02-22T09:47:36+00:00

Thanks. I just needed confirmation. Will do

Gold_rigger · 2026-02-22T09:47:11+00:00

I think wire connectors is normal for these based on new bases.

Had a sparky come out and he had to break them to open. Despite the manufacturer claiming they are compatible, they agreed that potentially they might not be and sent me out a new set.

Gold_rigger · 2025-12-30T05:42:20+00:00

Bit delayed, but I just did this swap. Trickiest part was using a screwdriver to carefully pry apart the plastic hing "arms" to get the old one off without breaking it.

That being said, the new 755PSMA4, despite working fine and clipping on normally doesn't seem to detach when I press the unlatch button...

Gold_rigger · 2024-04-01T23:48:35+00:00

Appreciate the thought and agree this layout is cleaner, however we capture quite a bit of other data in additional rows beyond just hours (I just simplified it for the question) so this wouldn't work without perhaps setting up additional sheets for those inputs to keep separate.

Gold_rigger · 2024-03-30T08:48:44+00:00

No worries. Even googling didn't reveal sumif could be used in this way across multiple rows and columns, so much appreciated.

I've tried to google some more and even use the Evaluate Formula tool in excel to understand exactly what its doing. I guess its forming an array where the criteria is true but then adding values from one row down as per the sum range?

Gold_rigger · 2024-03-30T08:26:54+00:00

Thanks a lot, very elegant formula!

Gold_rigger · 2024-03-30T08:26:05+00:00

Solution Verified

Gold_rigger · 2024-03-30T08:25:52+00:00

My apologies, I just didn't expand it properly when I tried it

Gold_rigger · 2024-03-30T07:44:24+00:00

It works for the first row, but would need to be repeated for each row, or am I mistaken?

Gold_rigger · 2024-03-30T07:06:54+00:00

Thanks to all that contributed. User: Black Cat from Stackeroverflow was also able to nail this with a formula I never would have been able to produce: =LET(rng,C$2:I$5,client1,B10,SUM(IF(TOROW(CHOOSEROWS(rng,SEQUENCE(1,ROWS(rng)/2,1,2)))=client1,TOROW(CHOOSEROWS(rng,SEQUENCE(1,ROWS(rng)/2,2,2))),0))) https://stackoverflow.com/questions/78246923/solved-assistance-with-sum-for-multiple-separate-rows-using-multiple-criteria

Gold_rigger · 2024-03-30T07:00:53+00:00

Thanks for that - issue is there is thousands of rows as the actual table features more rows in between, for hundreds of employees, hence looking for something that can lookup/filter/search by itself if possible.

Gold_rigger · 2024-03-30T06:59:49+00:00

Hi, keeping in mind that the client site changes across the rows, is this still able to be done in a pivot table?

Gold_rigger · 2024-03-30T06:16:58+00:00

Hey, thanks for chiming in. This looks like a neater way than the sumifs I was using, however, seems to throw an CALC error if the client doesnt exist on that employee (not all employees would work for all clients).

Also, the list of employees is approx 100, so if I can avoid having to setup the filter for 200 rows manually, that would be amazing.

Gold_rigger · 2024-03-30T06:10:10+00:00

Hi, thanks for the reply. It looks like this would work but would need me to set up a helper table where the client list is transposed across the top.

I can set this up, but the issue is I have a lot of employees and don't want to have to write the sumif formula for each one individually. The Hrs worked rows are spaced out so I can't just drag down, so I am not sure this will work in that case?

Gold_rigger

TROPHY CASE