software

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

Thanks--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: www.excelforum.com/member.php...oamp;userid=33055
View this thread: www.excelforum.com/showthread...hreadid=537753=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(we ights),weights)) /
SUMPRODUCT(IF(ISNUMBER(weights),weights))

Jerry

quot;inoexcelquot; wrote:

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


awesome, thanks Jerry!--
inoexcel
------------------------------------------------------------------------
inoexcel's Profile: www.excelforum.com/member.php...oamp;userid=33055
View this thread: www.excelforum.com/showthread...hreadid=537753You're welcome. Glad it helped.

Jerry

quot;inoexcelquot; wrote:

gt;
gt; awesome, thanks Jerry!
gt;
gt;
gt; --
gt; inoexcel
gt; ------------------------------------------------------------------------
gt; inoexcel's Profile: www.excelforum.com/member.php...oamp;userid=33055
gt; View this thread: www.excelforum.com/showthread...hreadid=537753
gt;
gt;