Didn't even read that far, thanks <g

--


Regards,


Peo Sjoblom

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Peo,

You overlooked the criteria that the values in column A be the same....

Bernie


"Peo Sjoblom" wrote in message
...
=SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4)

--


Regards,


Peo Sjoblom

"kalyan" wrote in message
...
is there any way to calculate the weighted mean in excel?
e.g weighted mean from A2:A4 = (B2*C2+B3*C3+B4*C4)/(B2+B3+B4)

this is just an example, i have a huge data of thre columns `A, B and
C`. i
need to calculate the weighted mean of column C WITH column B at
different
ranges matching with column A, such as for all the same values of column
A
(SAY 44) calculate the wiehted mean of corresponding values of column C
(12,
4, 5,8) with B (3, 9, 5, 6).