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: 870
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: s Ramchandran, Kristine Storti, Shanna Henseler
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Uwe von Gostomski
Jonathan Jones
drsven
Forum Stats:
Groups: 3
Forums: 24
Topics: 6212
Posts: 27237
Member Stats:
Guest Posters: 49
Members: 31889
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —