Forum Discussion
Sum Function Troubleshooting
I have a similar problem . This is my formula:
=SUM(AV5:AV265)
the column includes some numbers, some blanks, and some zeros. Many numbers come from somewhere else, so the cell will actually say, e.g., "=AB47" or something like that.
I have tried summing some of the subsections, since this span is 200 cells long. SOME subsections will sum, others will yield zero. I can't tell a diff between sections that work and those that don't
Hi Mary,
It doesn't matter do you have formulas inside or not, important are some of your cells contain text instead of numbers or not. For example, do you have text "$3" or number 3 formatted as USD.
To check you may compare
=COUNTA(AV5:AV265) and =COUNT(AV5:AV265)
if they are not equal that means you have some cells with text within the range.
You may also empty column starting from row 5 enter
=ISTEXT(AV5)
and frag it down. If returns TRUE you have the text here.
for the SUM any text, blank or zero adds zero to the total.