SUMIFS, multiple sheets??

edited 12/09/19 in Using Smartsheet
06/12/19 Edited 12/09/19


I'm trying to add amounts together from different sheets based on certain criteria. I have my data divided up across multiple sheets because it is more than 500 rows. Is this possible? If so, how do I do this?

My formula for a single sheet is: =SUMIFS({Dollar amount}, {Worksheet Range 1}, $ColC$14, {Worksheet Range 2}, ColA15, {Worksheet Range 3}, >=$Dates$1, {Worksheet Range 3}, <=$Dates$2)

I need the {Dollar amount} from multiple sheets. 


  • L@123[email protected] ✭✭✭✭✭

     the only way i know how you can do this is use sumifs()+sumifs()

  • Mike WildayMike Wilday ✭✭✭✭✭

    I agree with [email protected] You can add the sumifs statements together to get a complete total, But I would probably create a sheet to gather the data from each of the sheets for ease of use (Smaller formulas to maintain, easier to troubleshoot, etc,) and then sum the columns you have them all pulling in the data. 

  • Andrée StaråAndrée Starå ✭✭✭✭✭
    edited 06/12/19


    I agree with Mike and recommend collecting everything in a master metric sheet. It makes it easy to calculate and use the data in dashboards and similar if that need arises.

    Have a fantastic week!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

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

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    I suggest using the SUMIFS on the original sheets and then cell linking those totals to a metrics sheet where they can then be summed. This will help avoid the issue of too many cells from other sheets being referenced.

Sign In or Register to comment.