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