Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUMIF with criteria of cell containing a specific character
I am trying to use SUMIF with the criteria of a specific character (%) being
anywhere within the text of the cells in the criteria range. The character is not always in the same place within the text and never starts with the character so I was trying to use FIND but I couldn't come up with a way to do it. i.e. Summing column B cell values where column A cells have a "%" in it. A B 1 Carl Smith 10 2 Jim Hill% 15 3 Steve Camp 5 4 Mary% Levy 30 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF a cell only contains a specific character then reformat the tex | Excel Discussion (Misc queries) | |||
SUMIF, with specific search criteria | Excel Worksheet Functions | |||
Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
How do I remove all text in a cell after a specific character? | Excel Worksheet Functions | |||
Search for a specific character in a cell in an if statement | Excel Worksheet Functions |