COUNT IF + using 2 sets of data
 

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)

COUNT IF + using 2 sets of data
 

Maybe,

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

Mike

" wrote:

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)

COUNT IF + using 2 sets of data
 

yes great !! thank you very much!!!

COUNT IF + using 2 sets of data
 

=sumproduct((left(B1:B5,2)="BB")*(C1:C50))


wrote in message
oups.com...
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)

COUNT IF + using 2 sets of data
 

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


"Jim May" wrote in message
...
=sumproduct((left(B1:B5,2)="BB")*(C1:C50))


wrote in message
oups.com...
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)