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" <shekala.1zr8uy_1134101700.6386@excelforum-nospam.com> wrote in
message news:shekala.1zr8uy_1134101700.6386@excelforum-nospam.com...
>
> 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" <shekala.1zr8uy_1134101700.6386@excelforum-nospam.com> wrote in
> message news:shekala.1zr8uy_1134101700.6386@excelforum-nospam.com...
> >
> > 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
> >