| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex SUMIF question
Thanks everyone. Problem solved. I appreciate it.
"Toppers" wrote: =SUMPRODUCT(ISNUMBER(SEARCH({"FCOM","F/COM"},B1:B6))*C1:C6) "Peo Sjoblom" wrote: One possible way =SUM(SUMIF(B2:B6,{"*F/COM*";"*FCOM*"},C2:C6)) -- Regards, Peo Sjoblom "SkyGuy50" wrote in message ... Or I think it is a sumif, but I can't seem to make the conditional work so I'm not sure. Here is what I need to do. Add up all the numbers in column C if column B (text) includes the string "FCOM" or "F/COM" Sample data Column B Column C RSAS F/COM 25 RSAS MR 35 BES FCOM 5 UB/MR 10 F/COM, UB, MR 20 In this example, I want to add up rows 1,3,&5 and return 50. Can anybody help me out? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| another complex =IF question | New Users to Excel | |||
| How to use complex criteria in SUMIF() | Excel Worksheet Functions | |||
| Can I use more complex logical expression for sumif as creteria? | Excel Worksheet Functions | |||
| Complex Sort Question | Excel Worksheet Functions | |||
| SumIf formula with complex criteria | New Users to Excel | |||
Hybrid Mode
