Counting Multiple Instances
 

I need to count the number of times F shows in column C at the same time Y
appears in column n

Thanks

ce

Counting Multiple Instances
 

Try something like this:

=SUMPRODUCT((C1:C20="F")*(N1:N20="Y"))


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Curtis" wrote:

I need to count the number of times F shows in column C at the same time Y
appears in column n

Thanks

ce

Counting Multiple Instances
 

=SUMPRODUCT((C1:C5000="F")*(N1:N1000="Y"))
you cannot use full column references (C:C) with SUMPRODUCT, so adjust the
ranges as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Curtis" wrote in message
...
I need to count the number of times F shows in column C at the same time Y
appears in column n

Thanks

ce

Counting Multiple Instances
 

Opps =SUMPRODUCT((C1:C5000="F")*(N1:N5000="Y"))
must have equal sized arrays
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
=SUMPRODUCT((C1:C5000="F")*(N1:N1000="Y"))
you cannot use full column references (C:C) with SUMPRODUCT, so adjust the
ranges as needed
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Curtis" wrote in message
...
I need to count the number of times F shows in column C at the same time Y
appears in column n

Thanks

ce