Perhaps you could suppress the errors, if you have a formula like =A1/B1
then you could change to

=IF(B1,A1/B1,"")

then you only need a normal AVERAGE function


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=538585