One of these would be options:
=IF(COUNT(A1:C1)=0,"",SUM(A1:C1)/COUNT(A1:C1))
=IF(COUNT(A1:C1)=0,"",AVERAGE(A1:C1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
=SUM(A1,B1,C1)/COUNT(A1,B1,C1)How would you keep this error #DIV/0! from
showing up when nothing is in a cell. Thanks in advance!