Excluding a column from range in COUNTIF function
 

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 :)

Excluding a column from range in COUNTIF function
 

Hi,
try

=(COUNTIF($A:$A,B1)=0)*(B1<"")+COUNTIF($C:$N,B1)= 0)*(B1<"")

"connole99" wrote:

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 :)

Excluding a column from range in COUNTIF function
 

Hello,
Thanks a million but worked!!!! You're a star, thank you :)



"Eduardo" wrote:

Hi,
try

=(COUNTIF($A:$A,B1)=0)*(B1<"")+COUNTIF($C:$N,B1)= 0)*(B1<"")

"connole99" wrote:

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 :)

Excluding a column from range in COUNTIF function
 

You are very welcome, thank you for the feedback

"connole99" wrote:

Hello,
Thanks a million but worked!!!! You're a star, thank you :)



"Eduardo" wrote:

Hi,
try

=(COUNTIF($A:$A,B1)=0)*(B1<"")+COUNTIF($C:$N,B1)= 0)*(B1<"")

"connole99" wrote:

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 :)