Weighed Average
=Sumproduct(range with values,range with weights)/Sum(range with weights)
HTH,
Bernie
MS Excel MVP
"0-0 Wai Wai ^-^" wrote in message ...
Hi.
Does anyone know which function can do the "Weighed Average"?
Or do I need to combine several functions to do so?
Thanks.
--
Additional information:
- I'm using Office XP
- I'm using Windows XP
|