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?