Ravi Sir's Cards › Excel
Inventory and Warehouse Management System in Excel (card 1 of 2)
Revision card 1 for Inventory and Warehouse Management System in Excel: Line key per challan: =B5&"-"&COUNTIF($B$5:B5,B5) gives DC-101-1; Days in the period: =B3-B4+1 gives 17; Units received: =SUMIFS('Stock in'!$E$5:$E$500,'Stock in'!$C$5:$C$500,A5) gives 60. Includes an example data table.
Read card text
What this card says
1 for Inventory and Warehouse Management System in Excel: Line key per challan: =B5&"-"&COUNTIF($B$5:B5,B5) gives DC-101-1
Days in the period: =B3-B4+1 gives 17
Units received: =SUMIFS('Stock in'!$E$5:$E$500,'Stock in'!$C$5:$C$500,A5) gives 60. Includes an
Example
data table
Learn this in the lesson: Inventory and Warehouse Management System in Excel: Stock In, Stock Out, Days of Cover, Reorder, ABC and Challan