Project acceptance record formPreparation of:
1. It is used to fill in the various data measured on site one by one during the project acceptance process;
2. After the project acceptance, the summary of various forms and data is an important reference for measuring, assessing, and evaluating the quality of the project;
3. Save as archived data after the project is completed.
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)Recommended by the editor of Huajun Software Park
The Project Acceptance Record Form is a very practical form, and most of the forms filled in are for general purposes. If you happen to need to download the Excel form of the Project Acceptance Record Form, please download it quickly.Employee Onboarding Form Template,Attendance salary sheet templateIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works