AutoSum

Copper Contributor
My total includes the letter ‘J’
Help me figure this out?
4 Replies

Could you post your workbook or screenshots? We need some more info on what is happening. Have you checked the cell formatting?

@bon3407 

 

I think you may be getting confused with the formula bar up top and the results, the sum look fine to me! The formula bar display's the formula that is being calculated in each cell. The =SUM(J2:J1226) is telling you that the cells in column J, J2 all the way through J1226, are being summed. The total sum is the 2,752B number seen at the bottom, is being calculated correctly.

 

DKoontz_0-1637610971120.png

 

Also if this is sensitive information I would remove the example file.

 

Thank you.
Not sensitive info… state budget.