Sumif function?

[foxyspook]

Hello,

I am attempting to distribute a total quantity based on individual item demand * months of stock required. Some locations do not require any months of stock ie. 0.0 but I still need to distribute the total ie. 320. I completed this with a simple formula ie average demand * months of stock required however because some items do not require any stock my total for that item does not add up to 320, rather 328? I would greatly appreciate any assistance.

Total Qty Item Code average demand Months of stock required
320 3620407 48 0.0
320 3620407 72 1.1
320 3620407 56 2.2
320 3620407 7 0.4
320 3620407 32 2.1
320 3620407 27 0.2
320 3620407 20 2.5
75 3640085 14 1.7
75 3640085 17 1.0
75 3640085 4 1.5
75 3640085 11 0.0
75 3640085 28 0.1
75 3640085 40 1.3

[FDibbins]

This thread is marked SOLVED, did you figure out something? If so, what did you come up with?

If it is not SOLVED, let me know and I will reset that.

Was something like this what you meant?
=$A$2-SUMIF($B$2:B2,B2,$C$2:C2)
copied down

[FDibbins]

This thread is marked SOLVED, did you figure out something? If so, what did you come up with?

If it is not SOLVED, let me know and I will reset that.

Was something like this what you meant?
=$A$2-SUMIF($B$2:B2,B2,$C$2:C2)
copied down