Tips for using the latest inventory details
The connotation of inventory:
1. Inventory is the goods actually stored in the warehouse. It can be divided into two categories;
2. The first type is production inventory, which is the inventory of grassroots enterprises and institutions that directly consume materials. It is stored to ensure that the materials consumed by enterprises and institutions can be supplied uninterrupted;
3. The first type is circulation inventory, that is, the inventory of raw materials or finished products of production enterprises, the inventory of production authorities and the inventory of material authorities at all levels.
4. In addition, there are special forms of national reserve materials, which are mainly used to ensure the timely and complete supply or sale of materials to grassroots enterprises and institutions.
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)Recommended by the editor of Huajun Software Park
Latest inventory detailsIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the latest inventory details, please download it quickly. In addition,Employee body temperature registration form,Front desk visitor registration formIt is also a good form template. You are welcome to click to download and experience it.
Useful
Useful
Useful