# SUMIFS Across Two Sheets with Multiple Criterion

Options
✭✭✭✭

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

• Employee
Options

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

• ✭✭✭✭
Options

Hey Jaykel,

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

Options

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)

Cheers,

Genevieve

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!