Averaging a column that contains text
=IF(COUNT(B1:B12),AVERAGE(B1:B12),"NO NUMBERS")
--
Best Regards,
Luke M
"Malcolm" wrote in message
...
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
|