Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif statement
=sumproduct((a2:a22="dog")*(b2:b22="brown"))
-- Don Guillett SalesAid Software "italiavb" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif statement
Thanks Don, it worked perfectly
Ciao "Don Guillett" wrote in message ... =sumproduct((a2:a22="dog")*(b2:b22="brown")) -- Don Guillett SalesAid Software "italiavb" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif statement
Don,
Can the wildcard symbol (*) be used in the formula? "Don Guillett" wrote in message ... =sumproduct((a2:a22="dog")*(b2:b22="brown")) -- Don Guillett SalesAid Software "italiavb" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF statement with 3 criteria checks | Excel Discussion (Misc queries) | |||
Countif Statement | Excel Discussion (Misc queries) | |||
Can criteria in countif statement be a color? | Excel Worksheet Functions | |||
Adding an AND Statement to COUNTIF | Excel Worksheet Functions | |||
countif statement | Excel Worksheet Functions |