countif statement

's Computer Specifications

I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA IN
TWO DIFFERENT COLUMNS.

IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN MATCH.
SO THE ANSWER IN THIS CASE WOULD BE 2

I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
HELP.

A B C

DOG BROWN

CAT WHITE

MOUSE RED

DOG WHITE

DOG BROWN

CAT BROWN

's Computer Specifications

=sumproduct((a2:a22="dog")*(b2:b22="brown"))

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"italiavb" <(E-Mail Removed)> wrote in message
news:QMztg.15$(E-Mail Removed)...
>I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA IN
>TWO DIFFERENT COLUMNS.
>
> IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
> MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2
>
> I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
> HELP.
>
>
> A B C
>
> DOG BROWN
>
> CAT WHITE
>
> MOUSE RED
>
> DOG WHITE
>
> DOG BROWN
>
> CAT BROWN
>
>

's Computer Specifications

Thanks Don, it worked perfectly

Ciao

"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "italiavb" <(E-Mail Removed)> wrote in message
> news:QMztg.15$(E-Mail Removed)...
>>I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
>>IN TWO DIFFERENT COLUMNS.
>>
>> IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
>> MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2
>>
>> I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
>> HELP.
>>
>>
>> A B C
>>
>> DOG BROWN
>>
>> CAT WHITE
>>
>> MOUSE RED
>>
>> DOG WHITE
>>
>> DOG BROWN
>>
>> CAT BROWN
>>
>>
>
>

's Computer Specifications

Don,
Can the wildcard symbol (*) be used in the formula?

"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "italiavb" <(E-Mail Removed)> wrote in message
> news:QMztg.15$(E-Mail Removed)...
>>I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
>>IN TWO DIFFERENT COLUMNS.
>>
>> IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
>> MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2
>>
>> I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
>> HELP.
>>
>>
>> A B C
>>
>> DOG BROWN
>>
>> CAT WHITE
>>
>> MOUSE RED
>>
>> DOG WHITE
>>
>> DOG BROWN
>>
>> CAT BROWN
>>
>>
>
>

's Computer Specifications

Example of data

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"italiavb" <(E-Mail Removed)> wrote in message
news:9dBtg.929$(E-Mail Removed)...
> Don,
> Can the wildcard symbol (*) be used in the formula?
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>>
>> --
>> Don Guillett
>> SalesAid Software
>> (E-Mail Removed)
>> "italiavb" <(E-Mail Removed)> wrote in message
>> news:QMztg.15$(E-Mail Removed)...
>>>I AM TRYING TO COUNT THE NUMBER OF ROWS THAT TWO MEET DIFFERENT CRITERIA
>>>IN TWO DIFFERENT COLUMNS.
>>>
>>> IN THE EXAMPLE BELOW I WANT TO COUNT THE NUMBER OF ROWS DOG AND BROWN
>>> MATCH. SO THE ANSWER IN THIS CASE WOULD BE 2
>>>
>>> I TRIED USING "COUNTIF" "COUNTA", SEVERAL IF AND STATEMENTS. I NEED SOME
>>> HELP.
>>>
>>>
>>> A B C
>>>
>>> DOG BROWN
>>>
>>> CAT WHITE
>>>
>>> MOUSE RED
>>>
>>> DOG WHITE
>>>
>>> DOG BROWN
>>>
>>> CAT BROWN
>>>
>>>
>>
>>
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif? or IF statement??	paankadu	Microsoft Excel Worksheet Functions	2	9th Feb 2009 05:50 PM
COUNTIF(AND Statement	=?Utf-8?B?bGNjdWJi?=	Microsoft Excel Misc	2	31st Dec 2006 05:06 PM
If Statement with Countif	=?Utf-8?B?Q3Jhenlob3JzZQ==?=	Microsoft Excel Misc	3	10th Apr 2006 08:55 PM
OR statement inside a COUNTIF statement	Carla	Microsoft Excel Worksheet Functions	3	25th Jun 2004 07:38 PM
CountIf Statement	Philea_92	Microsoft Excel Discussion	2	16th Dec 2003 08:03 AM