weighted average

Hi, how do I calculated a weighted average, but excluding cells that have #div/0! or 0.

Thanks

=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(weights),weights)) /
SUMPRODUCT(IF(ISNUMBER(weights),weights))

Jerry

"inoexcel" wrote:

>
> Hi, how do I calculated a weighted average, but excluding cells that
> have #div/0! or 0.
>
> Thanks
>
>
> --
> inoexcel
> ------------------------------------------------------------------------
> inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
> View this thread: http://www.excelforum.com/showthread...hreadid=537753
>
>

awesome, thanks Jerry!

You're welcome. Glad it helped.

Jerry

"inoexcel" wrote:

>
> awesome, thanks Jerry!
>
>
> --
> inoexcel
> ------------------------------------------------------------------------
> inoexcel's Profile: http://www.excelforum.com/member.php...o&userid=33055
> View this thread: http://www.excelforum.com/showthread...hreadid=537753
>
>