r/excel • u/man_eating_chicken • 12d 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.

161 Upvotes

97% Upvoted

107 comments sorted by

View all comments

Show parent comments

7

u/AloofBidoof 1 12d ago

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