Log In
Register
Home
Help required for a novice user!
P Beauch
New Member
Members
Forum Posts: 1
Member Since:
February 19, 2019
February 19, 2019
Offline1
February 19, 2019 - 10:00 pm
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: 930
Member Since:
December 7, 2016
December 7, 2016
Offline2
February 20, 2019 - 3:13 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.myonlinetraininghu.....ata-format
https://www.myonlinetraininghu.....ivot-table
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 930
Purfleet: 415
Hans Hallebeek: 356
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Stephen Brown
D Roberts
MC Hoed
joseph lee
Simon Musker
Dennis M
Yiannis A
John Kang'ara
Forum Stats:
Groups: 3
Forums: 25
Topics: 7096
Posts: 31114
Member Stats:
Guest Posters: 49
Members: 34536
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —