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 zero1. 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 casewhat is up?

Thanks!

Hi, 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)Regards

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!

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

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

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History