View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SkyGuy50 SkyGuy50 is offline
external usenet poster
 
Posts: 2
Default Complex SUMIF question

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.