Fill in the contents of the kindergarten monthly plan:
1. Planning work serves to achieve organizational goals.
2. Planning work is the bridge of management activities and the basis of management activities such as organization, leadership and control.
3. Planning work is universal and orderly.
4. Plan work to pursue efficiency
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)
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park
Kindergarten monthly schedule contentIt is a very practical form, and most of the filling forms are for general purposes. If you happen to need to download the content template of the kindergarten monthly schedule, please download it quickly. also,Repair registration form,Decoration budget tableIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works