COUNTIF statements

I AM TRYING 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

You have a response at your other post.

italiavb wrote:
>
> I AM TRYING 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

--

Dave Peterson

thanks Dave.

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B6CC9F.BAB476ED@verizonXSPAM.net...
> You have a response at your other post.
>
> italiavb wrote:
>>
>> I AM TRYING 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
>
> --
>
> Dave Peterson