| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF in array
Hi
I have the following data: A B 22 Cat 29 Bat 22 Tax 24 Bat 22 Cat I want to calculate the total number (COUNT) of the occurences of "Cat" in Column B, where Column A's value is "22". I.e. the answer to the above example will be 2. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count in a cell, not an array | Excel Worksheet Functions | |||
| If, Count & Array | Excel Worksheet Functions | |||
| COUNT and IF Array | Excel Worksheet Functions | |||
| Count & Array Function | Excel Worksheet Functions | |||
| Count if array contains cells of a certain value | Excel Worksheet Functions | |||
Threaded Mode
