Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |