Supervision meeting Sign -in table usage skills
Preparation of the Sign -in Form for Supervision Meeting:
Preparation before the meeting: It is mainly for the management of meeting personnel information, conference information and other conference information management
Meeting execution: mainly to conduct meeting sign -in process processing
After the meeting, processing: Inquiry and report processing of the meeting
Supervision meeting Sign -in table common skills 1: Multi -condition count
Requirements: The number of people who are produced by the statistical and statistical departments and are mainly operated by their posts
The formula is:
= Countifs (B2: B9, F2, C2: C9, G2)
In the statistical condition area of the Countifs function, the number of cells that meet multiple specified conditions. The conventional usage is:
= Countifs (Condition area 1, specified condition 1, condition area 2, specified condition 2 ...)
2: Condition search
The VLOOKUP function has always been the existence of Volkswagen's lover. The syntax of the function is:
Vlookup (Who wants to find, where to find, return the content of the first column, find it precisely or approximate)
To check what positions of the employee name in the F5 cell.
= Vlookup ($ F $ 5, $ B $ 1: $ D $ 10, 2,0)
Xiaobian recommended by Huajun Software Park
Supervision meeting sign -in formIt is a very practical form, and most of the forms of filling in the form are commonly used. If you just need to supervise the signing of the meeting to download the download form, come and download it. also,Application form for financial reform project financial excavation funds,Statistics of teaching resultsIt is also a good table template, please click to download the experience!
it works
it works
it works