Counting Multiple Instances

[Guest]

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

Thanks

ce

 

[Guest]

Try something like this:

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


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

XL2002, WinXP

 

[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

 

[Bernard Liengme]

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