Counting Multiple Instances

C

Curtis

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

Thanks

ce
 
R

Ron Coderre

Try something like this:

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


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

XL2002, WinXP
 
B

Bernard Liengme

=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
 
B

Bernard Liengme

Opps =SUMPRODUCT((C1:C5000="F")*(N1:N5000="Y"))
must have equal sized arrays
 
Top