Another way:
=IF(COUNT(B35:B47)0,AVERAGE(B35:B47),"")
Jim Anderson wrote:
I am using the formla:
=average(b35:b47)
to put the average of cells b35 to b47 into cell b48.
Is there a way to avoid the cell b48 showing the result :
#DIV/0!
when I have no entries in the range of aforementioned cells?
Thank you
Jim
--
Dave Peterson
|