1, first of all, to establish a purchase schedule, daily registration of goods purchased in, including the date, name, unit, unit price, quantity, amount and so on.
2, and then create a sales schedule, with the contents of the purchase schedule is similar, but only registered daily sales.
3, after the establishment of a good sales schedule, and then create an inventory table, the name of the goods, according to the purchase schedule to fill in, each of the goods only need to fill in once.
4, in the inventory table B3, enter the following formula: = SUMIF (into the goods! B: B, A3, into the goods! E: E), to express the meaning of: A3 in the name of the goods shall prevail, the number of statistics of goods.
5, in the inventory table C3, enter the following formula: = SUMIF (Sales! B: B, A3, Sales! E: E), to express the meaning is: A3 in the name of goods prevail, the number of sales statistics.
6, in the inventory table D3, enter the following formula: = B3 - C3, to express the meaning of: the number of balances = the number of incoming goods - the number of sales.
7, the third line of the formula entered after the formula, hold down the formula to pull down, fill in the other cells, so that the inventory form is ready, you can automatically count the number of daily inventory.