Solved excel sum formula returns 0

Microsoft Excel 2003 (full product)
April 28, 2010 at 09:51:31
Specs: Windows XP
Hi -

I'm pretty good with lots of excel formulas (counts, database, financial, and the basics), so I must be missing something really obvious here.

I've been using excel all morning, and sent a file to someone for input. After I got the file back, any excel file I open and try to do a basic sum of two rows returns zero.

Cell 1: 100
Cell 2: 3
Cell 3 =sum(a1:a2) returns zero

1. I've checked the calculation window and it is set to automatic
2. I've checked the cell format and made sure it's numbers.
3. I even cut and pasted the cells as values and numbers just in case

what is up?


See More: excel sum formula returns 0

April 28, 2010 at 11:48:47
✔ Best Answer

Assuming the values are in Cells A1 and A2:

1. Does = A1 + A2 return 301
2. What happens if you do =LEN(A1)
3. Does SUM() work on other workbooks
4. Do similar functions work e.g., AVERAGE(A1:A2)


Report •

April 28, 2010 at 13:22:58
It returned zero.
Sum wasn't working in any workbooks

I tried the classic "close the app and reboot" approach, and voila, the formula now works.

Mystery......but I'm back in action.

Thanks for your reply!

Report •

July 21, 2010 at 05:40:44
have u found the answer?
I'm having the same problem right now.
and the sheet is too big for me to re-write the whole new sheet.


Report •

Related Solutions

July 21, 2010 at 07:49:08
Hi hsdpa78,

The person who started this thread said that they did find a solution - see response #2.

If you have a problem, please use a new post, not a response to an old one, and describe your problem in detail
- what does not work
- what happens when you try it - any error messages, or error values in cells,
and include a sample of the data and formula(s) causing the problem.


Report •

Ask Question