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     www.energyefficientbuild.com.    Jan 20, 2013
user Gary Fang said:(http://productforums.google.com/forum/?zx=soh9zupgmep1#!category-topic/docs/spreadsheets/Nkys3gNzOnE)
Calculate inventory
Hi,

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,

Gary
--------------------------------------------------------------------------------------------------
following is a solution to the problem