sumproduct may work
=sumproduct(--($C$2:$C$21581=2189),--($X$2:$X$21581=true))


--
paul
remove nospam for email addy!



"fishbio" wrote:

Hi,
i'm obviously a novice at this. but, can someone tell me what's wrong with
this formula?
=(COUNTIF(IF $X$2:$X$21581=$X2,$C$2:$C$21581, "=2189, "0")))

I'm trying to count the number of cells in c2:c21581 that are = 2189 as
long as the condition in x2:x21581 is true.

thanks.