Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My original question:
I have a countif formula (see post: variation on countif) that reads Countif(A1:A100,"*value*"). The situation is that users were asked to list their past isp's and could list more than one in a cell. So, is there a way to say "Count this cell if the cell includes either 'aol', 'america online', or 'america on-line'"? The reply: one way: just add the COUNTIF statements. Another way: =SUM(COUNTIF(A1:A100,{"*aol*","*America Online*","*america on-lin*"})) Next question: The only thing is, I want to make sure that people who replied with something like "america online (aol)" don't get counted twice. That's the reason behind this question. Thanks, Liz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
combining countif formulas | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
CountIF across multiple sheets in a workbook | Excel Worksheet Functions |