| 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 |
| 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 | |||
Threaded Mode
