SUMIFS - multiple criteria refrencing another sheet

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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!