| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Countif with multiple criteria in the same column.
=SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"})) -- Regards, Peo Sjoblom (No private emails please) "Harley" wrote in message ... I need to count different criteria from the same column. For example, under the column Names, the criteria for one breakout might be Tom, Beth, John, Roger; the next breakout might be Joe, Sue, Randy, Bob. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria using countif | Excel Worksheet Functions | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
| COUNTIF or SUMPRODUCT counting multiple criteria | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
