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: 880
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: Alan Sidman, Lorna Henning
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —