Summing a column dependent on text and value



I am looking for a formula to sum a column but only count those cells that meet certain criteria. Please see the example below.

The formula should be in the highlighted cell. It should count all the cells in the "Repair Category" column that are "4" AND are FSA AND Warranty in "Request Type". It should exclude cells that are 4 in "Repair Category" and Trans in "Request Type".

Hopefully that makes sense!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!