| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF where the criteria is 'if contains a string'?
I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but
the criteria should be 'the cell (within the range B1 to B100) contains the string in cell C1'. How is it possible? Thanks, Michael |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where the criteria is 'if contains a string'?
Sat, 23 Feb 2008 08:19:00 -0800 from Michael
: I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but the criteria should be 'the cell (within the range B1 to B100) contains the string in cell C1'. How is it possible? =Sumif(A1:A100,C1) Sometimes things are simpler than we think. :-) -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com A: Maybe because some people are too annoyed by top posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top posting such a bad thing? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where the criteria is 'if contains a string'?
On Sat, 23 Feb 2008 08:19:00 -0800, Michael
wrote: I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but the criteria should be 'the cell (within the range B1 to B100) contains the string in cell C1'. How is it possible? Thanks, Michael Use wildcards: =sumif(a1:a100,"*"&C1&"*",b1:b100) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where the criteria is 'if contains a string'?
That's it, thanks a lot Ron!
"Ron Rosenfeld" wrote: On Sat, 23 Feb 2008 08:19:00 -0800, Michael wrote: I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but the criteria should be 'the cell (within the range B1 to B100) contains the string in cell C1'. How is it possible? Thanks, Michael Use wildcards: =sumif(a1:a100,"*"&C1&"*",b1:b100) --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where the criteria is 'if contains a string'?
On Sat, 23 Feb 2008 09:08:00 -0800, Michael
wrote: That's it, thanks a lot Ron! You're welcome. Glad to help. Thanks for the feedback. --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where the criteria is 'if contains a string'?
Sat, 23 Feb 2008 11:46:45 -0500 from Stan Brown
: Sat, 23 Feb 2008 08:19:00 -0800 from Michael : I would like to do something similar to: SUMIF(A1:A100,"<"&C1,B1:B100) but the criteria should be 'the cell (within the range B1 to B100) contains the string in cell C1'. =Sumif(A1:A100,C1) Sometimes things are simpler than we think. :-) But this is, alas, not one of them. Sorry; I overlooked the condition on range B1 to B100. Luckily, Ron has already given you a solution. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com A: Maybe because some people are too annoyed by top posting. Q: Why do I not get an answer to my question(s)? A: Because it messes up the order in which people normally read text. Q: Why is top posting such a bad thing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| String criteria in DCOUNT function | Excel Worksheet Functions | |||
| Need Advanced Filter with NOT equal string and OR criteria | Excel Discussion (Misc queries) | |||
| I need to do a sumif on data that [contains] a specific string. | Excel Worksheet Functions | |||
| Search string with multiple criteria | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
Linear Mode
