Weighted Average function

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

Maybe

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

with values in A and weights in B

--
Regards,

Peo Sjoblom

(No private emails please)


"shekala" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a weighted average function in Excel? if not, any clever ideas
> on how to create one?
>
>
> --
> shekala
> ------------------------------------------------------------------------
> shekala's Profile:
> http://www.excelforum.com/member.php...o&userid=27986
> View this thread: http://www.excelforum.com/showthread...hreadid=492080
>

An alternative way using "sum":
{=sum(A1:A10*B1:B10)/sum(B1:B10)}

Peo Sjoblom wrote:
> Maybe
>
> =SUMPRODUCT(A1:A10,B1:B10)/SUM(B1:B10)
>
> with values in A and weights in B
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "shekala" <[email protected]> wrote in
> message news:[email protected]...
> >
> > Is there a weighted average function in Excel? if not, any clever ideas
> > on how to create one?
> >
> >
> > --
> > shekala
> > ------------------------------------------------------------------------
> > shekala's Profile:
> > http://www.excelforum.com/member.php...o&userid=27986
> > View this thread: http://www.excelforum.com/showthread...hreadid=492080
> >