View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Clear Cell If Function = 0


I'd suggest either

=IF(COUNT(I61:I69),AVERAGE(I61:I69),"")

or

=SUM(I61:I69)/MAX(1,COUNT(I61:I69))


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