You can use an array formula like

=AVERAGE(IF(O8:O38<"",O8:O38))

entered with ctrl + shift & enter

will not return an error unless all the cells are blank


--

Regards,

Peo Sjoblom



"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