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,991 times
Add to favorites
E-mail Twitter Digg Facebook