formula question
 

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.

formula question
 

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.

formula question
 

Hi, I'm a novice too but it looks like you have 2 brackets at the start
and 3 at the end, not sure if this is the problem??


--
BankC
------------------------------------------------------------------------
BankC's Profile: http://www.excelforum.com/member.php...o&userid=26337
View this thread: http://www.excelforum.com/showthread...hreadid=502364