SUMIFS Across Two Sheets with Multiple Criterion

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!