Sunday, January 20, 2013

yogi_From Items Bought And Items Sold Columns Compute Updated Inventory of items In Stock

                                          Google Spreadsheet  Post  #983
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 20, 2013
user Gary Fang said:(!category-topic/docs/spreadsheets/Nkys3gNzOnE)
Calculate inventory

So, I bought different Items (A, B, C, D, E, F, G) at different quantity (3, 5, 8, 8, 10, 15, 20); then I sold some Item (C, F, G) of quantity (2, 4, 8),

Data like this:
Item Buy Item Sold
A 3 C 2
B 5 F 4
C 8 G 8
D 8
E 10
F 15
G 20

I want to calculate inventory of (A, B, C, D, E, F, G). Someone suggested use arrayFormula, sumif, but I don't know how, please help.

Thanks a lot,

following is a solution to the problem