One way:
=IF(ISERROR(AVERAGE(R76:R87)),"",AVERAGE(R76:R87))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---
"John Calder" wrote:
In cell R88 I have the following formula

=AVERAGE(R76:R87)

It works fine as soon as I enter data in the range but when there is no data
in the range it returns a #DIV/0! error.

This looks unsightly on the sheet and was wondering if there was a way that
I could surpress this error when there is no data entered.

Thanks

John