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

David Joyeuse

Hi @Corentin Dal Farra

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.

Corentin Dal Farra

Hello @David Joyeuse

Thanks for your help !

Corentin