Excluding a column from range in COUNTIF function

  • Thread starter Thread starter connole99
  • Start date Start date
C

connole99

Does anyone know how to exclude a column from a range in the COUNTIF
function? Example: =(COUNTIF($A:$N,B1)=0)*(B1<>"") but I want to exclude the
B column from the range. Any suggestions?? Thanks :)
 
Hi,
try

=(COUNTIF($A:$A,B1)=0)*(B1<>"")+COUNTIF($C:$N,B1)=0)*(B1<>"")
 
Hello,
Thanks a million but worked!!!! You're a star, thank you :)
 
You must log in or register to reply here.

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

Dsum Help 0
Conditional Formatting based on active Named Range; IF Function to VBA 1
Excel Need Countifs Formula Help 0
countifs Function not giving desired result with date criteria 2
Countif Function Using "AND" 3
Exclude certain text from =COUNTA 2
SUMIF with criteria "<>" & "=" 4
SumIf and CountIf Multiple Criteria 8

Back
Top