Thread: Complex Countif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe Mac Joe Mac is offline
external usenet poster
 
Posts: 40
Default 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