| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif Function w/ multiple Criteria
I am trying to count the occurances on the following labels in a row
LOA, TRN,VAC I can only get 1 of the lable to return the number I need to added the other 2, this is the formula I used =COUNTIF(K226:X226,"TRN") But I need it to be something like this to return a value of 3 =COUNTIF(K226:X226,"TRN,VAC,LOA") Active LOA Active Active Active Active Active Active Active Active Active TRN VAC Active |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the CountIf function with multiple criteria? | Excel Worksheet Functions | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Multiple criteria countif/sumproduct function | Excel Worksheet Functions | |||
| COUNTIF or SUM function (Multiple criteria) HELP!! | Excel Worksheet Functions | |||
| countif function with multiple criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
