Please leave the statistical formHow to fill in?
1. Seek truth from facts, do not exaggerate, avoid suspicion of "making excuses".
2. I have a hand book, and the leave of the leave is generally handwritten by me. Special circumstances can be written by others, but you need to explain in the text that if you print it, the name of the money must be handwritten.
3. Simply and clear words, and the leave bar must be concise and clear. Generally, only the reason for writing clearly, the time and hope of the leave of leave, and the hope of getting approved.
4. Take a leave of time, this is very important, it must be put on, clear.
5. Wishes. Bless the other party, this is the friendship of all the official documents.
6. Signature of the fake person. Your own signature does not need to press the fingerprint, you only need to sign.
7, leave time. Fill in the current time you wrote a fake bar.
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)
When using this function, you need to pay attention to the following points:
1. The 4th parameter is generally found in accurate matching by 0 (or fasle).
2. The column number in the 3rd parameter cannot be understood as the actual column number in the worksheet, but the specified column of the return value in the search range.
3. If the data type of the finding value is inconsistent with the data type of the data area, the error value will be returned.
4. The search value must be located in the first column in the query area.
Xiaobian recommended by Huajun Software Park
Please leave the statistical formIt is a very practical form, and most of the forms of filling the form are commonly used. If you just need to ask for the statistical table, come and download it. also,Investigation registration form for patients with disease,Materials fundraisingIt is also a good software, please click to download the experience!
it works
it works
it works