Count of occurances within another count

[Guest]

I need to find how many instances of "jul*" have a "y"
B
1 Jun 123
2 Jun 234
3 Jul 123
4 Jul 123
5 Jul 234
6 Aug 123
7 Jul 234
I have tried variations of SUMPRODUCT, COUNT, and INDEX/MATCH, but only get total counts of "y", error, or 0.

 

[Andy B]

Hi

Try:
=SUMPRODUCT((LEFT(B1:B7,3)="Jul")*(L1:L7="y"))

--
Andy.

I need to find how many instances of "jul*" have a "y".
B L
1 Jun 123 y
2 Jun 234 y
3 Jul 123 n
4 Jul 123 y
5 Jul 234 y
6 Aug 123 n
7 Jul 234 y
I have tried variations of SUMPRODUCT, COUNT, and INDEX/MATCH, but only

get total counts of "y", error, or 0.

 

[Guest]

Thanks! That worked great. I tried variations of LEFT, but not this particular one

----- Andy B wrote: ----

H

Try
=SUMPRODUCT((LEFT(B1:B7,3)="Jul")*(L1:L7="y")

--
Andy

I need to find how many instances of "jul*" have a "y"
B
1 Jun 123
2 Jun 234
3 Jul 123
4 Jul 123
5 Jul 234
6 Aug 123
7 Jul 234
I have tried variations of SUMPRODUCT, COUNT, and INDEX/MATCH, but onl

get total counts of "y", error, or 0

 

[Andy B]

Thanks for the feedback!!

--
Andy.

Thanks! That worked great. I tried variations of LEFT, but not this particular one.

----- Andy B wrote: -----

Hi

Try:
=SUMPRODUCT((LEFT(B1:B7,3)="Jul")*(L1:L7="y"))

--
Andy.


only
get total counts of "y", error, or 0.