Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF statements
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF statements
thanks Dave.
"Dave Peterson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use nested countif statements? | Excel Worksheet Functions | |||
countif using multiple if statements | Excel Worksheet Functions | |||
COUNTIF STATEMENTS | Excel Worksheet Functions | |||
IF, COUNTIF & AND STATEMENTS | Excel Discussion (Misc queries) | |||
Countif Statements | Excel Programming |