Using wildcards with IF statements, or add a 2nd criteria (probably an easy fix)

[NewbieExcel123]

Hi all,

This is most likely an easy fix, I wanted to use wildcards to find the word "Pass" which covers criteria "Pass" and "Pass (Advisory)", however I've discovered you can't use Wildcards with IFs?
I'm also thinking it may be easier to just add a 2nd criteria to the formula to capture "Pass (Advisory)" as well as "Pass", but I'm unsure how to do this?

I have this formula

=LET(f,FILTER($P$5:$P$100,$O$5:$O$100="AO"),s,SEQUENCE(ROWS(f)),fr,FREQUENCY(IF(f="Pass",s),IF(f="Fail",s)),SUM(--(fr>=5)))*0.5

It counts how many times Pass appears in sequence against an AO or EO criteria before the word Fail appears

Column P	Column O
AO	Pass
AO	Pass
AO	Pass
EO	Pass
EO	Fail
EO	Pass
EO	Pass (Advisory)
EO	Pass
AO	Pass
AO	Pass (Advisory)

Thank you

 

[Fluff]

Duplicate to: Sum Frequency IF formulas with multiple criteria

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.