Even if you dont have the text in B6 it will return the error...when you dont
have any numbers in that range...Try

=IF(COUNT(B1:B12),AVERAGE(B1:B12),"")

--
Jacob (MVP - Excel)


"Malcolm" wrote:

On my worksheet I have a column of12 cells that I need to average.
Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0!
displays in cell B13 until any rates are inputted into the column. After
inputting the first rate the formula works great. I’m using the formula;
=AVERAGE(B1:B12). Is there another formula I could use that will not display
the #DIV/0! in cell B13 ? I’m using Excel 2007.
A B
1
2
3
4
5
6 Name
7
8
9
10
11
12
13 #DIV/0!
Thank you,
Malcolm