Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
87
Views
Topic starter
Hi all,
I am trying to get excel to total Fees from one work sheet to another BUT it needs to be split into months
So, for example, for the month of February, all the fees need to be added together in one table and continue to do so until we reach March.
I hope this makes sense.
I have attached a copy of my spreadsheet in case I am talking gibberish!
Posted : 20/02/2019 8:00 am
Hello,
I suggest you work with your data in a tabular format and then use a Pivot Table to summarize the sum per month.
https://www.myonlinetraininghub.com/excel-tabular-data-format
https://www.myonlinetraininghub.com/pivot-table
Posted : 20/02/2019 1:13 pm
