How do I add another word to filter this formula

Andrew Miles

I would like this formula to pull "WIP" jobs and "Offsite work". how do i add this

=SUM(SUMIFS({Dates}, {departments}, "Fabrication", {status}, "WIP")) * 1.25

Zachary Hall

Here is how I would write what I think you may be looking for:

• =SUM(SUMIFS({Dates}, {departments}, "Fabrication", {status}, "WIP"), SUMIFS({Dates}, {departments}, "Fabrication", {status}, "Offsite work")) * 1.25

I hope this helps!

Zachary Hall

Here is how I would write what I think you may be looking for:

• =SUM(SUMIFS({Dates}, {departments}, "Fabrication", {status}, "WIP"), SUMIFS({Dates}, {departments}, "Fabrication", {status}, "Offsite work")) * 1.25

I hope this helps!

Andrew Miles

Thank you, that is exactly what i was looking for.