Forum Discussion
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 at a total line, also horizontally across the top lists months Jan. thru Dec. with a year to date total on the far right Column for each category. Any help or tutorial would be greatly appreciated.
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
