Weighted Average function

S

shekala

Is there a weighted average function in Excel? if not, any clever ideas
on how to create one?
 
P

Peo Sjoblom

Maybe

=SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)

with values in A and weights in B

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top