Complex SUMIF question

[Guest]

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.

 

[Peo Sjoblom]

One possible way

=SUM(SUMIF(B2:B6,{"*F/COM*";"*FCOM*"},C2:C6))

 

[Guest]

try
=sumproduct(isnumber(search("FCOM",B1:B5))+isnumber(search("F/COM",B1:B5)),C1:C5)

 

[Guest]

=SUMPRODUCT(ISNUMBER(SEARCH({"FCOM","F/COM"},B1:B6))*C1:C6)

 

[Guest]

Thanks everyone. Problem solved. I appreciate it.