Sumif

[iamlisa]

Hi,

Appreciate your help for below data;

A B D
16030001 CTC BY 7TH 100.00
16030002 TS PERDIM BY 7TH 200.00
16030003 TS BY 7TH 300.00
TS SHELL 100.00
TS BY 7TH APP 20.00
SC BY 7TH 80.00
SC BY 7TH FLEX 70.00
SC 200.00
PERDIM 50.00
TS 10.00
SHELL 10.00
BY 7TH 10.00
CTHLBB BY 7TH 60.00

I would like to sum if;
1) Column A is blank then column B contain TS but does not contain BY 7TH & FLEX
2) Column A is blank then column B contain TS & SC but does not contain BY &7TH.

Thank you

 

[AliGW]

Can't make head nor tail of the data - sorry. Could you provide it in tabular format, please?

 

[Aladin Akyurek]

The exhibit requires reworking to make sense of it... That said:

1.

=SUMIFS(D:D,A:A,"=",B:B,"=TS*",B:B,"<>*BY 7TH & FLEX")

>> 130 for the exhibit you posted.

2.

=SUM(SUMIFS(D:D,A:A,"=",B:B,{"TS*","SC*"},B:B,"<>*BY 7TH*"))

>> 310 for the exhibit you posted.

Note. It's better to also provide the expect results along with the data and questions.