Forum Discussion
Autosum not working
What am I doing wrong. the data is formatted as numbers. I have used paste special X1. This is the result. I am a well practiced but relatively basic user. I set the sum for B6.
Nichole_Peterson
Microsoft
MicrosoftHi jlockley! This is the Agent 365 discussion space. I think you'll more likely find an answer in the Excel discussion space:
Excel | Microsoft Community Hub
That said, as a well-practiced but relatively basic user myself, I think you'd want that formula to be in the C6 box and have it =sum(C1:C5) -- that should add up all five individual payments. Hope that helps; have a good day!