Sum FUnction Not working properly

ManyIdeas

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

heyjay

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.

Jim B

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