Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"Joe Mac" wrote:

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