Try this:

=AVERAGE(IF(YourRange0,YourRange))

This is an array function and should be committed with ctrl+shift+enter
(not just enter)


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=521051