Counting problem

[vickyho1008]

I have three columns with pure text

e.g. Column A Column B Column C
Open Y Fund1
Open N Fund2
Open Y Fund 3
Closed N Fund4
Closed Y Fund5

How could I count the number of Funds that are both "open" and "Y"?
(i.e. in the example above is 2)

many thank

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100="Open"),--(B1:B100="Y"))

 

[vickyho1008]

it works, many thank