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
|