=SUMPRODUCT(IF(ISNUMBER(data),data),IF(ISNUMBER(we ights),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