Autosum returns zero balance - why?

M

MarcyC

Excel 2003
I've been adding both contiguous and non-contiguous numbers using the
autosum function OR =c2+c5+c9 OR =SUM(c2,c5,c9) OR =SUM(a1:a50). In a few
places I now get a zero where once the total appeared. I've tried locating a
circular reference error but there isn't one. I've been using these formulas
for years and never had a problem like this before. What am I missing? Please
help!
 
J

John Bundy

Press F9 and see if they change, the auto calulation may have been turned
off. Tools->Options->Calculation will tell you as well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
autosum 1
An Odd problem with SUM using : 0
problem summing columns with dates 2
Autosum returns an incorrect zero value on the selected cells 4
Data Entry - Write to next cell & next blank line 0
First row where a cell is zero 2
An odd problem with SUM(A:B) and AutoSum 2

Top