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?
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