1． Purchase price (the *digit of the supply unit is the price);
2. Transportation and miscellaneous charges (including transportation charges, loading and unloading charges, insurance premiums, packaging charges, warehousing charges, etc.);
3. Reasonable losses during transportation;
4. Selection and sorting costs before storage;
5. Taxes and other charges for purchased materials.
1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
Material Procurement Cost Calculation Sheet is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Material Procurement Cost Calculation Sheet, please download it quickly.Item claim form,Supplier file management formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works