Can I use COUNTIF with OR?

  • Thread starter Thread starter AA Arens
  • Start date Start date
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
 
Hi
One way

=IF(COUNTIF(Area1!$B$2:$B$7,A4)+COUNTIF(Area2!$B$2:$B$7,A4)>=1,"",ROW())
 
=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With SQL 2
Help With SQL Update 1
Do You Have A SQL Query For This Problem? 1
IF and Lookup 5
Prefix with TOC--any way to trick Word into doing it? 1
2-letter TOC prefixes--any kind of workaround? 2
Over complicated Calculation? 4
Multiple CSS files - proper way to do this when you have a master page? 6

Back
Top