SUMIFS, multiple sheets??

cpezz

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. 

L_123

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

Mike Wilday

I agree with L@123. 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å

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

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