| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 :) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
| can't use function 'countif' in named range | Excel Worksheet Functions | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Countif Function for dates in a range | Excel Worksheet Functions | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
Hybrid Mode
