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