View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
italiavb italiavb is offline
external usenet poster
 
Posts: 19
Default 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