SUMIFS - multiple criteria refrencing another sheet

Alyssa_OBrien

Hello - I need help with a SUMIFS formula referencing another sheet.

I would like it to sum the tech count column if the request type is "FSA" and the FW01 column is "true"

Here is my formula that is currently not working:

=SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true"})

Tech Count Range 1 = Tech Count column ( value to be summed)

Tech Count Range 2 = Request Type Column

Tech Count Range 3 = FW01 Column

Thank you!

Samuel Mueller

@Alyssa_OBrien if the formula you have there is an exact copy then you have an extra "}" after true that shouldn't be there. try

=SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true")