| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF with criteria of cell containing a specific character
=SUMIF(A2:A50,"*%*",B2:B50)
-- Regards, Peo Sjoblom "Bob Arnett" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF with criteria of cell containing a specific character
You can use wildcards with SUMIF, so try this:
=SUMIF(A:A,"*%*",B:B) Hope this helps. Pete On Nov 7, 12:13*am, Bob Arnett wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using SUMIF with criteria of cell containing a specific character
Well, duh. Of course one would use a wildcard... what's wrong with me.
Thanks to both of you for your responses. "Bob Arnett" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
