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
>>
>>
>
>