Ashish Mathur Wrote:
Hi,

You may use the following array formula (Ctrl+Shift+Enter):

=average(if((F49:J490),F49:J49))

Regards,

Ashish Mathur



That stills gets you the #DIV/0 error message, which the OP was getting
originally, when all cells in the range are 0


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=494713