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?