Sum FUnction Not working properly
I am trying to get the total value for a column and the math is completely off. has anyone encountered this? all i am doing is a simple sum. the total should be 703 not 595
Answers

Can you try to remove the numbers one by one and see what row/number is not affecting the formula.
When you remove the number bring it back when you jump on the next row.
...

Hello, I came here looking for an answer to a similar problem. Didn't find it here but I did figure it out eventually.
I was pulling numbers from other sheets into my formula which was not calculating as expected.
My fix was to make sure each cross sheet reference was converted from text into a number using VALUE(yourreference@row) in the cell where I had my formula.
I know this is an old thread. Just leaving this here in case someone else needs it.
Jim
Help Article Resources
Categories
Check out the Formula Handbook template!