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

autosum 1
Min+Max from other Tabs 4
An odd problem with SUM(A:B) and AutoSum 2
Cannot SUM times 4
decrease integers to zero 7
Sum if not blank 2
Value of zero = 2.44422537765132E-14 1
Averaging blank or cells with Zeros in them. 4

Top