1. Company name, date, department head, general department reviewer, and attendance person.
2. Employee’s name, job number, and position.
General Tips for Monthly Attendance Sheets
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
Monthly attendance sheetIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Kindergarten teacher resume form,Production capacity and working hours statistics tableDownload to get the source file, which you can edit, modify and replace. To download the employee attendance sheet, go to Huajun Software Park
it works
it works
it works