Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Complex Countif
I'm attempting to construct a countif statement which is conditional on 2
seprate columns of data using the following formula produces a 0 response =COUNTIF($K:$K,(AND($C:$C=1,$I:$I=0))) What I need: Count the numeric values in "K" IF the values in "C" are equal to 1 AND the values in "I" are equal to 0 I'm using the entire columns in the formula do to the fact that the number of data rows extracted from another system is variable daily Any assistance would be appreciated... -- Joe Mac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF - more complex | Excel Worksheet Functions | |||
Complex or Conditional Countif(s) | Excel Worksheet Functions | |||
Countif Function, complex criteria | Excel Worksheet Functions | |||
Even more Complex COUNTIF functionality | Excel Worksheet Functions | |||
help please - complex countif, etc. functions | Excel Worksheet Functions |