P Beauch
New Member
Members
Forum Posts: 1
Member Since:
February 19, 2019
February 19, 2019
Offline
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!
Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 899
Member Since:
December 7, 2016
December 7, 2016
Offline
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.myonlinetraininghu.....ata-format
https://www.myonlinetraininghu.....ivot-table
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Michael V Bernot, Kris Gula, Jay Quick
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29981
Member Stats:
Guest Posters: 49
Members: 33568
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —