Hello - need help! :) Summing data from multiple sheets.

Tammy Parker

Hello

I have 5 sheets of many cells of data for different work groups within my organization. I need to create ONE summary sheet that totals each of the cells from the 5 sheets.

The only way I can figure out how to do it is by creating the =sum( reference another sheet) five times for each cell... it will take me forever... LOL

Is there a way to do it smoother and faster?

Thanks so much!

Andrée Starå

Hi Tammy,

We can probably use SUMIF(S) instead.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tammy Parker

Thanks Andree,

I might be able to explain. I have five sheets exactly the same, in Excel they would have been TABS. I then normally, in excel would add a summary or totals tab where I could ADD all the data together.

I am doing a training assessment, all teams need to provide same information, how many employees at each site, how many use lap tops, locations, etc...

I need to be able to report out on this assessment with total numbers for all teams.

I think I figured out if I use report, I can pull in all the sheets and columns and then export to excel to manipulate the data the way I want.... not sure if that is the best way... LOL

Does this help??

Thanks as always for your help

Andrée Starå

@Tammy Parker

Happy to help!

Yes, a report and then export to excel works, but if you want to have the current numbers always updated, you could create a so-called Master Metrics Sheet instead.

You'd use cross-sheet formulas from each sheet to collect the metrics.

Make sense?