Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I can't figure out how to count occurrences of a wildcard matching certain
criteria. For example, let's say I want to count the number of cells containing words ending in "ing" - even if those cells contain other words besides the one ending in "ing". How do I do that? And then, out of that count, how do I count only the number of those cells which also contain a value of "X" in the same row one column to the right? Let me give a visual: A B C 1 slow ending X 2 slow beginning X 3 fast ending In this example, there are 3 cells in column A that contain a word that ends in "ing", and out of those 3, 2 of them have an X in column B. What formula would I use in this situation to account for the wildcard *ing, and to count only those occurrences that also have an X in column B, to give the value of 2 in the cell containing this formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) |