SUMIFS, multiple sheets??

SUMIFS, multiple sheets??

cpezzcpezz
edited 12/09/19 in Using Smartsheet

Hello,

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. 

Comments

  • 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

    Hi,

    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!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • 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.