If I could shag any excel formula it’d be “sumproduct”

Just a top notch formula.

1 Like

I feel like I only use VLOOKUP nowadays. Anything else I’ll SQL it.

2 Likes

CLEAN for me, I think.

<3 CLEAN so much.

Same

1 Like

Yeah but if you’re trying to pick up several columns based on criteria as well as rows then you’re fucked

I’ll probably use a sql aggregate function or something

How long does that take? Got the sumproduct done in about 30 secs

XLOOKUP > VLOOKUP

1 Like

29 seconds roughly

1 Like

VLOOKUP 4Lyf

1 Like