| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT and IF Array
For every occurrence of a string in B9 in the current worksheet, I want to
count the number of cells that contain the letter W in Lineup Worksheet F2:F83, where the string in Lineup Worksheet B2:B83 matches the string in B9. I have tried using this formula but it counts all of the values in F2:F83; I only want a count of those contaiing W. =COUNT(IF($B9='Lineup Worksheet'!$B$2:$B$83,IF('Lineup Worksheet'!$F$2:$F$83="W",0,0))) Thanks, Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count & Array Function | Excel Worksheet Functions | |||
| Inconsistent Array Count results | Excel Worksheet Functions | |||
| Count If Array Formula | Excel Worksheet Functions | |||
| Count if array contains cells of a certain value | Excel Worksheet Functions | |||
| How can you use count with an array formula similar to using sum | Excel Worksheet Functions | |||
Threaded Mode
