Forum Discussion
Solved
Problem with a SUM function not working properly
Something bizarre has happened with my Excel files. As an example, I have a cell that performs the operation =SUM(F4 + F5). The data put into that cell is correct for the defined operation. For pu...
Hi Kenneth,
Are your Calculation Options set on Automatic?
Look at the row line-numbers. if there are gaps, that could be your problem. For example: if rows 15 and 16 are missing and you're trying to sum rows 1 through 20 in column a: change =sum(a1:a20) to =sum(a1:a14)+sum(a17:a20) - until you figure out how to get all your row numbers back (you can try copying and pasting all your information into a new worksheet).