COUNT IF + using 2 sets of data

[mail]

A B C

1 BB 6
2 BB
3 a 5
4 a 5
5 BB 5


ok, still a beginner so i need simple answers.

what i want to do is count the number of non blank entrys in colum C
based on only those that are labled BB in B.

I feel like this should be very simple COUNT option similar to
SUMIF(B1:B5,"BB",C1:C5)

 

[Mike H]

Maybe,

=SUMPRODUCT((B1:B5="BB")*(C1:C5<>""))

Mike

 

[mail]

yes great !! thank you very much!!!

 

[Jim May]

=sumproduct((left(B1:B5,2)="BB")*(C1:C5>0))

 

[Jim May]

Make that:
=sumproduct((left(B1:B5,2)="BB")*((C1:C5<>"")))