Sum Various Sheets

Nicole Hodges

Hello!

I am wanting to connect multiple sheets and sum on each parent level.

Each sheet has the same strucutre. I am looking for a "grand total" of many parent rows on these sheets.

How do I go about this? 

Andrée Starå

Hi Nicole,

You could use cell-linking or cross-sheet references to collect everything in a so-called master metric sheet and sum everything there.

Would that work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

There are a few different options depending on your exact setup and needs.

 

My recommendation would be to sum up each sheet individually on each respective sheet.

 

From there you could either cell link each sheet to your metrics sheet then add all of them together, or you can use cross sheet references in a SUM formula.