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
|