Engineering project cost analysis tableHow to fill in?
⑴ Analysis of the cost of partial item
本 Month, quarterly cost analysis
Annual cost analysis
Comprehensive analysis of completion cost
The if function is one of the most commonly used judgment class functions, which can complete the judgment of this or the other.
The criteria for assessment scores are 9 points, and it is necessary to determine whether the assessment scores of column B are qualified.
= If (B4> = 9, "Qualification", "Unqualified")
2: Multi -conditional judgment
If the department has high temperature subsidies for production and positions. Use formula in column D:
= If (and (b2 = "production", c2 = "main operation"), "Yes", "None")
3: Conditions Seeking peace
Calculate the total score of a class with the Sumif function:
= Sumif (D2: D5, F2, C2: C5)
4: Sumif usage is:
= SUMIF (conditional area, specified peaceful condition, the area where peace is required)
The description is described in popular words:
If the class in the D5 area is equal to the "one class" of the F2 cells, the region of C2: C5 C5 is required to sum up.
Xiaobian recommended by Huajun Software Park
Engineering project cost analysis tableIt is a very practical form, and most of the forms are used in common purposes. If you just need the cost analysis table of the project project, come and download it. also,Recruit college graduates registration registration form,Investment income budget formIt is also a good software, please click to download the experience!
it works
it works
it works