COUNT IF + using 2 sets of data

's Computer Specifications

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)

's Computer Specifications

Maybe,

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

Mike

"(E-Mail Removed)" 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)
>
>

's Computer Specifications

yes great !! thank you very much!!!

's Computer Specifications

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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)
>

's Computer Specifications

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

"Jim May" <(E-Mail Removed)> wrote in message
news:YC2ni.1155$(E-Mail Removed)...
> =sumproduct((left(B1:B5,2)="BB")*(C1:C5>0))
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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)
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I count sets of cells in two columns?	David	Microsoft Excel Worksheet Functions	2	30th Jul 2008 10:21 PM
Excel graph 3 sets of data. 2 sets as lines 1 as column?	AndyN	Microsoft Excel Charting	2	11th Jul 2008 01:18 PM
count cells with year sets in a column?	=?Utf-8?B?QnJhaW5sZXNzX2luX0Jvc3Rvbg==?=	Microsoft Excel New Users	3	4th May 2006 10:12 PM
How to count sets of numbers	JimDandy	Microsoft Excel Charting	2	29th Mar 2006 10:45 PM
Count rows that match 3 sets of criteria?	=?Utf-8?B?RXJpY0U=?=	Microsoft Excel Worksheet Functions	3	29th Dec 2005 04:26 PM