Summing a column dependent on text and value

Options

Hello,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!