Ravi Sir's Cards › Excel
Shop Billing and Inventory System in Excel (card 2 of 2)
Revision card 2 for Shop Billing and Inventory System in Excel: Closing stock: =C5+D5-E5 gives 58; Purchased quantity: =SUMIFS(Purchases!$D$5:$D$300,Purchases!$B$5:$B$300,A5) gives 40; Sold quantity: =SUMIFS(Sales!$D$5:$D$500,Sales!$B$5:$B$500,A5) gives 62. Includes an example data table.
Read card text
What this card says
2 for Shop Billing and Inventory System in Excel: Closing stock: =C5+D5-E5 gives 58
Purchased quantity: =SUMIFS(Purchases!$D$5:$D$300,Purchases!$B$5:$B$300,A5) gives 40
Sold quantity: =SUMIFS(Sales!$D$5:$D$500,Sales!$B$5:$B$500,A5) gives 62. Includes an
Example
data table
Learn this in the lesson: Shop Billing and Inventory System in Excel: Items, Purchases, Sales, Stock Reorder, Profit and Daily Cash Book