You will receive at #DIV/0 error if there is no data in O3:O38.
Try the formula below:
=IF(COUNT(O8:O38)=0,"",AVERAGE(O9:O38))
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"scott45" wrote in message
...
In my spreadsheet I have a formula that when no information is
entered it is
blank using "". At the bottom of this column o8:o38 I want to
average, this
column. My formula always returns DIV error. I have read
through the help and
tried just about everone (it seems) with the same result. I
have tried IF's
Is Error's etc still DIV
=IF(O8:O38="","",AVERAGE(O8:O38))-This one returns value error
=IF(Iserror(IF(O8:O38="",0,AVERAGE(O8:O38)-This returns not
enough (
Thanks in advance
scott