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: 100Cell 2: 3Cell 3 =sum(a1:a2) returns zero1. I've checked the calculation window and it is set to automatic2. 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 casewhat is up?Thanks!

See More: excel sum formula returns 0

#1
April 28, 2010 at 11:48:47
 Hi,Assuming the values are in Cells A1 and A2:1. Does = A1 + A2 return 3012. What happens if you do =LEN(A1)3. Does SUM() work on other workbooks4. Do similar functions work e.g., AVERAGE(A1:A2)Regards

Report •

#2
April 28, 2010 at 13:22:58
 It returned zero. Sum wasn't working in any workbooksI 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 •

#3
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.thanks

Report •

Related Solutions

#4
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.Regards

Report •