weighted average function

[stevel227]

Do you know of a formula or UDF that will return weighted averages? I use SUMPRODUCT(data)/SUM(weights) all the time to create weighted averages, but it would be nice if there was a "WAVERAGE" or "WTDAVG" function that combined the two for me.


Steve

 

[Luke M]

Looking at Microsoft:

http://support.microsoft.com/kb/214049


and Chandoo:

http://chandoo.org/wp/2010/06/15/weighted-average-excel/


It looks like you've already got the simplest way to do it. Yes, you could create a UDF that essentially combines the two functions for you, but it would probably by "slightly" less efficient than the native functions.