FIFO Costing with Excel Data Table using inward and outward table

Calculate inventory balance in cell H6 : =SUMIF($D$6:D6,D6,$E$6:E6)-SUMIF($D$6:D6,D6,$G$6:G6) Input your ID in cell S3 and beginning date in cell O3. Calculate number of units outward that deducted from units  inward in cell J6 : =IF( AND(Id=IdKey,Date>=From,E6>0), MIN(

 
 
 
 
 
5 Star
(1)
1,991 times
Add to favorites
Office
10/18/2012
E-mail Twitter del.icio.us Digg Facebook