A B C D E F G H I
124504501800 170 TN439 14-May 160 06/04/12 TN440 124504501800 80
124504501100 36 TN440 14-May 160 06/04/12 TN440 124504501100 168
126636631800 86 TN439 14-May 90 06/04/12 TN440 124504501800 120

I am trying to work up a formula that would allow me to add quantity received (I) to quantity on hand (B) by part numbers (H).

For example: If the item number is 124504501800 and I received 80 pieces in I would like a formula to add this to my existing inventory under that part number.

Does this make sense?

The cell columes are A-I above....and 1-3 Rows

Thanks

Ceej