Summing a column dependent on text and value

Amanda Medina

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!

Paul Newcome

Try this then...

=COUNTIFS([Repair Category]:[Repair Category], CONTAINS("4", @cell), [Request Type]:[Request Type], OR(@cell = "FSA", @cell = "Warranty"))

Paul Newcome

Are you looking for a count of rows or to sum the repair category based on the criteria?

Amanda Medina

Hi Paul,

I am looking for a count of rows.

How many rows have Category 4, and are listed as either FSA or Warr?

Paul Newcome

Try this then...

=COUNTIFS([Repair Category]:[Repair Category], CONTAINS("4", @cell), [Request Type]:[Request Type], OR(@cell = "FSA", @cell = "Warranty"))

Amanda Medina

That worked! Thank you!

Paul Newcome

Happy to help. 👍️