Sum data from different sheets
Corentin Dal Farra
✭✭✭✭✭✭
Hello everyone,
Do you know how to sum values from different sheets into one unique value on one single sheet ?
In my business case I have 5 different clients and one sheet per client. For each client I have the amount of sales by month.
I want to have the total amount of sales on a 6th sheet that sum all my sales for each client per month.
I only see two options :
- Make cell links in the 6th sheet for each client, and then make a sum children to have total
- Make several formulas that go in each sheet and sum the sales, and then add all theses sums into one formula
Does anyone know if there is a better way of doing this ?
Thank you, have a nice day,
Corentin
Answers
-
Well you can use this formula:
=SUM({Range Cust#1},{Range Cust#2},{Range Cust#3},{Range Cust#4},{Range Cust#5})
Range being the column you want to sum on each sheet.
Hope it helped.
-
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives