SUMIFS Across Two Sheets with Multiple Criterion

Brendan Ginns

Hi All,

I am looking for a the next step of this formula, I now want to include a department filter on this SUM Formula instead of all departments? is that possible

=SUMIF({Timesheet Range 1}, =[Export Title]@row, {Timesheet Range 4}).

Timesheet Range 1= Phase Name - Sheet 1

Export Title= Phase Name - Sheet 2

Timesheet Range 4 = Total Cost - Sheet 1

NEXT Step Add This into Equation

Timesheet Range 2 = Department Name- Sheet 1

Department= "Name" - Sheet 2

Jaykel Torres

Hey @Brendan Ginns,

Instead of using the SUMIF Function, which can only accept a single criteria, use the SUMIFS Function which works with multiple criteria. You may add the Department Range and Name criteria alongside your pre-existing criteria. I've created the example below to demonstrate this:

Formula (highlighted in yellow): =SUMIFS(Cost:Cost, Item:Item, "Apple", Type:Type, "Fruit")

I hope this helps!

Jaykel

Brendan Ginns

Hey Jaykel,

this is a great example. Do you know if this works on cross sheet formulas? Let me know

Genevieve P.

Hi @Brendan Ginns

Yes! To change this to be a cross-sheet formula you just need to adjust the column ranges.

Instead of typing Cost:Cost, you would use a cross-sheet reference, {Cost Column}

So in your instance, something like this:

=SUMIFS({Timesheet Range 4}, {Timesheet Range 1}, [Export Title]@row, {Timesheet Range 2}, Name@row)

See: Cross-sheet formulas

Cheers,

Genevieve