Can I use COUNTIF with OR?

A

AA Arens

I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
is this statement if the condition not only applies for the area in
Area1, but also in Area2 to have the value ""?
So, it is like COUNTIF Area1 OR Area2 True, False

Bart
 
R

Roger Govier

Hi
One way

=IF(COUNTIF(Area1!$B$2:$B$7,A4)+COUNTIF(Area2!$B$2:$B$7,A4)>=1,"",ROW())
 
B

Bob Phillips

=IF(OR(COUNTIF(Area1!$B$2:$B$7,A4),COUNTIF(Area2!$B$2:$B$7,A4)),"",ROW())

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top