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

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!

Answers

  • Andrée Starå
    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, [email protected])

    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • 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å
    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?

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!