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

I am sure sumproduct would do it


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=492080

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
> >
> > 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
> >