This sounds like what I need, also. Except in my situation, the cells I need
to find the average of are not contiguous.

"Domenic" wrote:


Try...

=AVERAGE(IF(ISNUMBER(A1:A10),A1:A10))

...entered using CONTROL+SHIFT+ENTER.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=271242