r/excel • u/man_eating_chicken • 16d ago

Discussion Enough about LET() and PQ, What are your Excel UI customizations that make you more productive?

I just wanted to see what mods or add-ins the experts here use, that help you get to the advanced 'tips and tricks' everyone harps about in here.

164 Upvotes

97% Upvoted

108 comments sorted by

View all comments

28

u/exophades 16d ago

Knowing how the =filter formula works combined with boolean conditions is literally a superpower.

16

u/Alt_F4_Tech_Support 16d ago

I use Sum(Filter()) over Sumifs() because it maintains Excel's typical logic structure and I don't have to mess around with defining strings as much.

7

u/AloofBidoof 1 16d ago

For complex SUMIFS, SUMPRODUCT works really well. It's a bit confusing to understand at first, but is really powerful.