Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question Criteria
I'm trying to sum numbers where the criteria is SOTB. In my data, SOTB is
often, but not always, buried in other text, but the function seems to ignore any item which contains any words other than SOTB. Is there some way I get it to recognize any entry that contains SOTB anywhere in the cell? Thx all Dave |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question Criteria
Try something like this:
For data in A1:A10 Col_A contains text Col_B contains numbers C1: =SUMIF(A1:A10,"*SOTB*",B1:B10) Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Dave" wrote: I'm trying to sum numbers where the criteria is SOTB. In my data, SOTB is often, but not always, buried in other text, but the function seems to ignore any item which contains any words other than SOTB. Is there some way I get it to recognize any entry that contains SOTB anywhere in the cell? Thx all Dave |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question Criteria
Case sensitive? If case sensitive
=SUMPRODUCT(--(ISNUMBER(FIND("SOTB",A1:A30))),B1:B30) if not =SUMIF(A1:A30,"*SOTB*",B1:B30) where A is the range with SOTB and B the range you want to SUM -- Regards, Peo Sjoblom Portland, Oregon "Dave" wrote in message ... I'm trying to sum numbers where the criteria is SOTB. In my data, SOTB is often, but not always, buried in other text, but the function seems to ignore any item which contains any words other than SOTB. Is there some way I get it to recognize any entry that contains SOTB anywhere in the cell? Thx all Dave |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question Criteria
Bingo -
Thank you Ron & Peo *SOTB* works like a charm. Much appreciated Dave "Peo Sjoblom" wrote in message ... Case sensitive? If case sensitive =SUMPRODUCT(--(ISNUMBER(FIND("SOTB",A1:A30))),B1:B30) if not =SUMIF(A1:A30,"*SOTB*",B1:B30) where A is the range with SOTB and B the range you want to SUM -- Regards, Peo Sjoblom Portland, Oregon "Dave" wrote in message ... I'm trying to sum numbers where the criteria is SOTB. In my data, SOTB is often, but not always, buried in other text, but the function seems to ignore any item which contains any words other than SOTB. Is there some way I get it to recognize any entry that contains SOTB anywhere in the cell? Thx all Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif question | Excel Worksheet Functions | |||
SUMIF question (I think) | Excel Worksheet Functions | |||
this may be simple, sumif question | Excel Worksheet Functions | |||
sumif Question | Excel Discussion (Misc queries) | |||
SUMIF question | Excel Worksheet Functions |