countif statement

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

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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"italiavb" <pdestasio@bellsouth.net> wrote in message
news:QMztg.15$iP1.10@bignews2.bellsouth.net...
>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
>
>

Thanks Don, it worked perfectly

Ciao

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:ONmXjxspGHA.3288@TK2MSFTNGP03.phx.gbl...
> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "italiavb" <pdestasio@bellsouth.net> wrote in message
> news:QMztg.15$iP1.10@bignews2.bellsouth.net...
>>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
>>
>>
>
>

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

"Don Guillett" <dguillett1@austin.rr.com> wrote in message
news:ONmXjxspGHA.3288@TK2MSFTNGP03.phx.gbl...
> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>
> --
> Don Guillett
> SalesAid Software
> dguillett1@austin.rr.com
> "italiavb" <pdestasio@bellsouth.net> wrote in message
> news:QMztg.15$iP1.10@bignews2.bellsouth.net...
>>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
>>
>>
>
>

Example of data

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"italiavb" <pdestasio@bellsouth.net> wrote in message
news:9dBtg.929$cu1.609@bignews3.bellsouth.net...
> Don,
> Can the wildcard symbol (*) be used in the formula?
>
> "Don Guillett" <dguillett1@austin.rr.com> wrote in message
> news:ONmXjxspGHA.3288@TK2MSFTNGP03.phx.gbl...
>> =sumproduct((a2:a22="dog")*(b2:b22="brown"))
>>
>> --
>> Don Guillett
>> SalesAid Software
>> dguillett1@austin.rr.com
>> "italiavb" <pdestasio@bellsouth.net> wrote in message
>> news:QMztg.15$iP1.10@bignews2.bellsouth.net...
>>>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
>>>
>>>
>>
>>
>
>