Introduction to promotion plan form
List of contents of the promotion plan:
1. Establish a work coordination mechanism.
2. Establish an expert consultation mechanism.
3. Establish a performance evaluation mechanism.
1: Multi-condition counting
Requirements: Count the number of people in the statistics department who are in production and whose positions are master operators
The formula is:
=COUNTIFS(B2:B9,F2,C2:C9,G2)
The COUNTIFS function counts the number of cells in a conditional area that meet multiple specified conditions. Common usage is:
=COUNTIFS(condition area 1, specified condition 1, condition area 2, specified condition 2...)
2: Conditional search
The VLOOKUP function has always been a favorite among the public. The syntax of the function is:
VLOOKUP (Who are you looking for, where are you looking for, which column of content is returned, exact or approximate)
You want to query the position of the employee name in cell F5.
=VLOOKUP($F$5,$B$1:$D$10,2,0)
Promotion planIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Compulsory carrier liability insurance coverage statistics table,Survey form on financial investment in education fundsDownload to get the source file, which can be edited, modified and replaced. To download the promotion plan, go to the Huajun Software Park.
Useful
Useful
Useful