average formula

Highlighted
New Contributor

hello . simple problem. I am trying to use an average formula for a row of numbers. I followed the instructions for putting the formula into the cell but when I hit enter the only thing that shows up in the formula cell is # symbol. if I click on the cell it shows the formula in the bar up top but it's not giving me the numerical average for the row. I used it on a different part of the spreadsheet and it works fine. not sure what's wrong. help!!

4 Replies
Highlighted

@teacher_rich Would be helpful if you could upload an example or a screenshot showing the content of the cells you want to average and the formula you entered. For instance, if the average results in a negative and the cell format is (perhaps by mistake) set as Time, then you get ###########. 

Highlighted

54
68
72
90
62
60
90
73
0
94
0
49
67
85
86
74
82
70
72
91
68
86
72

#

 

so this is the row of numbers i'm trying to average and the formula cell is at the bottom showing #.

the numbers are in row AD and the individual cells are all set to general format.

this is the formula that's in the cell:

=AVERAGE(AD102:AD125)

 

@Riny_van_Eekelen 

Highlighted

I did the same thing on a different row and it worked fine so im not sure?

thanks for looking into it..

@Riny_van_Eekelen 

Highlighted

@teacher_rich 

If you make column AD wider do you still have # ?