Looking for a solution for keeping up with inventory of a part numbers.

[mdean32]

I'm having trouble figuring out a way to keep subtracting real time inventory (Column D) for part # AA as it continues to show up on a production schedule. Any ideas on a formula considering part AA may show up multiple times on a schedule with 500 other part numbers. Thanks for the help

A B C D
Qty to be produced Part # Raw inv Real time inv
200 AA . 1000 . 1000

900 AA 1000 -100

100 bb 100 . 100

300 cc 200 . 200

400 AA 1000 -500

 

[Nishant94]

Is this what you are looking for:

=IF(COUNTIF(B$1:B2,B2)=1,C2,C2-SUMIF(B$1:B2,B2,A$1:A2))

 

[mdean32]

Perfect!!!! Thank you so much!!!!!