View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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 :)