Thread: Excluding a column from range in COUNTIF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
connole99 connole99 is offline
external usenet poster
  
Posts: 2
Default 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 :)
Reply With QuoteReply With Quote