| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count text based on multiple (2) conditions
I want to be able to count the number of times text occurs in one column
based on a match with a different condition in the second column. The formula: =SUM(IF{(A199:A216="Karratha",IF(B199:B206="DET",1 ,0)))} returns #N/A when entered as an array and returns 1 when entered as normal. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parsing text in a multiple column count | Excel Worksheet Functions | |||
| Justify text across multiple columns | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| Can I count in an array based on a function? | Excel Worksheet Functions | |||
Threaded Mode
