Surpress Average Error

[John Calder]

Hi

I have a range of cells P619 that have no data in them and a formula in
cell P20 that is =AVERAGE(P619).

This returns a #DIV/0! error

This of course is no problem once I start to enter data into the range, but
I would like to surpess this #DIV/0! error when there is no data in the range.

Thanks


John

 

[Max]

One way to suppress:
=IF(ISERROR(AVERAGE(P619)),"",AVERAGE(P619))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[Dave Peterson]

=if(count(p619)=0,"no data yet",AVERAGE(P619))

 

[John Calder]

Thanks both Dave's answer and yours work great !

John