1. Duration.
Duration is an important indicator of progress.
2. Description based on the number of results and status of the project progress.
3. The value of the completed project.
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)
The project schedule is a very practical form, and most of the forms are for general purposes. If you just need to download the project schedule, please download it quickly.Activity service site list,Detailed list of administrative expensesIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works