Sumif value ignore two cell value

[silambarasan.J]

Hi Excel Forum.

I want sumif value excluding two cells.(A11 and A19)

Data:

Part Qty

A1 6925283 1
A2 6021309 1
A3 BS5-24P 1
A4 AC5R-24 1
A5 6253081 1
A6 6921080 1
A7 6071042 1
A8 6964076 1
A9 6215251 1
A10 6719233 1(Ignore Value)
A11 100-280 1
A12 FSG6300 1
A13 6254606 1
A14 6253930 1
A15 1477H 1
A16 1700000 1
A17 6243855 1
A18 108-109 2(Ignore Value)
A19 6925159 4

Desired Result:

Part Desired Results

G4 AC5R-24 1
G5 6253081 1
G6 6921080 1
G7 6071042 1
G7 6719233 0(Desired Results)
G8 6241550 20
G9 6246857 15
G10 6941084 1
G11 108-109 0(Desired Results)

Sum 40.

File attached.please help me.

[Special-K]

=sumif(a1:a18)-a11

[ChemistB]

Since you're not giving any specific criteria as to why to ignore those values, there are a couple possibilities

One
In B11 and B19, put a ' before the value, it won't show but will treat the value as text so it will not be counted

Two
Subtract those cells from your final number
Keeping with your original formula. In I5

=SUMIF($A:$A,$G$4:$G$12,$B:$B)- IF($G$4:$G$12 = $A$11, $B$11,0)- IF($G$4:$G$12 = $A$19, $B$19,0)
I'd go with option 1.

[silambarasan.J]

Special-K & ChemistB

thank you so much for your reply sir.