Counting symbols in two columns

Kimberley O

I am trying to determine a formula that will count the number of "flags" in one column if there is not a symbol in the second column. In the example below, there is only one flag that I want counted. Basically, the green/red/yellow symbol would cancel out counting the red flag if that makes sense.

JamesB

@Kimberley O

An COUNTIFS Statement is what you are looking for.

=COUNTIFS([Test passed?]:[Test passed?], ="", [Check if customer cancelled or was no-show]:[Check if customer cancelled or was no-show], =1)

JamesB

@Kimberley O

An COUNTIFS Statement is what you are looking for.

=COUNTIFS([Test passed?]:[Test passed?], ="", [Check if customer cancelled or was no-show]:[Check if customer cancelled or was no-show], =1)