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.

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.

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

"SkyGuy50" wrote:

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.

=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.

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.