Formula not functioning

[Camel123]

Hi,

Would really appreciate input on how I can get my formula working.

Excel screen shot:
https://imgur.com/a/9JC8UhS

How I want the formula to function:

If "Group" in column B= 1000 or 2000, in this case B8 and B9,

then,

I want the formula to sum all costs in column C, except for the costs where B equals 1000 and 2000. In this case sum all costs except C8 and C9.

then,

I want the formula to multiply the summed amount by 10 % if B=1000, and by 20 % if B= 2000.

I tried the following formula but did not really work, please note I am an Excel-amateur:
=IF(OR(B8=1000;B8=2000);SUMIFS($C$2:$C$1000;B:B;"<>1000";B:B;"<>2000");"");IF(B8=1000;C8*0,1;"");IF(B8=2000;C8*0,2;"")

 

[jtakw]

Yes this seems to be what I am looking for, I will try it once I get back to work and let you know

If you get a #NAME? error, need to know what version of Excel you're working on, may need to switch to SUMPRODUCT function.