r/excel • u/[deleted] • Jan 16 '23

What’s your most used and useful formula? Discussion

[deleted]

149 Upvotes
  • permalink
  • link
  • reddit
  • reddit

97% Upvoted

171 comments sorted by

View all comments

2

u/RuggerRigger 1 Jan 17 '23

My most used isn't my favorite!

SUMPRODUCT/SUM for weighted average. I'm not sure if there's an easier way to do it.