The Value of Sharing & Formula for a Weighted Average

One of the things I love about Excel, is how other people find new & different solutions. I remember one day working on a file of a co-worker and seeing a formula that made no sense to me, but it was calculating exactly what we needed.

When I asked him about it, he smiled. We talked, he explained how it worked. He was able to share and be appreciated for his knowledge and I learned a new technique.

Sometimes the thing that someone else needs is something you take for granted.

So, I'll kick off this thread with a solution for a weighted average.

=SUMPRODUCT( Range1, Range2) / Sum(Range1)

This does a weighted average, using the cells in Range1 as the weights.

What's something you've learned recently?

0 comments