=AVERAGE(IF(A1:A6<0,(B1:B6)*(A1:A6)))
array entered (ctrl+shift+enter)

where A1:A6 are the values from where non zeros are to excluded and
B1:b6are the weights


"bj" wrote in message
...
what weighting do you want to use?

"jeffsfas" wrote:


I've used sumproduct and array formulas before, but does anyone know how
to calculate a non-zero weigthted average in Excel for a range of
numbers? Thanks for the help.


--
jeffsfas
------------------------------------------------------------------------
jeffsfas's Profile:
http://www.excelforum.com/member.php...o&userid=24462
View this thread:
http://www.excelforum.com/showthread...hreadid=380573