Forum Discussion
Sta140_Fin_Sec
Dec 07, 2020Copper Contributor
New user tutorials for excel
New to office 365 just downloaded to my Dell laptop and Apple IPad. Any suggestions for a rookie in setting up an Excel spreadsheet that lists categories down the left side vertically and adds sums a...
Dec 07, 2020
I am assuming your table as in the photo,
So, the category 1 total will be on cell B10 for Jan, and this is the formula =sum(b2:b9)
and for the months, the total will be on the cell N2, and this is the formula =sum(B2:m2)
and so on.
Please check these thinks for using sum function in excel
https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89