using if Or statement

[tomhow]

Howdo I modify the formula below to includea 2nd criteria. I want to check if the value in range Crng is equal to f OR c. I have tried several ideas but none work. Any guidance would be welcome. I am trying to count the number of unique items in range Nrng where the adjacent cell in range Crng is equal to f or c.


=SUM(--(FREQUENCY(IF(Crng="f",MATCH(Nrng,Nrng,0)),ROW(Nrng)-ROW(C2)+1)>0))

 

[AhoyNC]

Try:
This is an array formula and must be entered with CTRL-SHIFT-ENTER.

=SUM(IF(FREQUENCY(IF((Crng="f")+(Crng="c"),MATCH(Nrng,Nrng,0)),ROW(Nrng)-ROW(C2)+1),1))

 

[tomhow]

Brilliant, I would never have thought of using the plus sign. Thanks AhoyNC for your quick reply

 

[AhoyNC]

You're welcome. Thanks for the feedback