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

Google spreadsheet is here: https://docs.google.com/spreadsheet/ccc?key=0AkE5S6t8o413dG8zWHlDb2NpcExtQl84QWN6S1puY1E#gid=0

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