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