or Explore Discussions

# SUMIFS, multiple sheets??

edited 12/09/19
06/12/19 Edited 12/09/19

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.

• ✭✭✭✭✭

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

• ✭✭✭✭✭

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.

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

SMARTSHEET PARTNER & CONSULTANT / EXPERT

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 about help with Smartsheet, integrations, general workflow advice, or something else entirely.

• ✭✭✭✭✭

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.