=IF(SUM(C20:C31)=0,"",SUM(C20:C31)/COUNTIF(C20:C31,"0")
Vaya con Dios,
Chuck, CABGx3
"fivermsg" wrote:
ok.. both worked.. but now i have dif problem. when i autofilled the
formula into my other rows I and O my row C turned.. Now instead of
zero's, it displays, #DIV/0! . the formalas no longer work cause it is
not zero.. how would you correct this??
--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521051