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