Track Number of Sick Days Taken
I need to count how many times 'Sick Leave' appears in an employee's annual attendance record.
=COUNTIF(B2:B16,"Sick Leave") How it works: The COUNTIF function is designed to count cells within a specified range that meet a single criterion. In this scenario, `B2:B16` is the range containing the attendance statuses for an employee. `"Sick Leave"` is the criterion, telling Excel to count only those cells within the range that contain the exact text 'Sick Leave'. This provides HR Managers with a quick and accurate tally of sick days taken.
Data Setup
| Date | Attendance Status |
|---|---|
| 2023-01-01 | Present |
| 2023-01-02 | Present |
| 2023-01-03 | Sick Leave |
| 2023-01-04 | Present |
| 2023-01-05 | Sick Leave |
| 2023-01-06 | Vacation |
| 2023-01-07 | Present |
| 2023-01-08 | Sick Leave |
| 2023-01-09 | Present |
| 2023-01-10 | Present |
| 2023-01-11 | Sick Leave |
| 2023-01-12 | Present |
| 2023-01-13 | Holiday |
| 2023-01-14 | Present |
| 2023-01-15 | Sick Leave |
Step-by-Step Guide
Enter your employee attendance data into an Excel sheet. Ensure the 'Attendance Status' is in a dedicated column (e.g., Column B).
Select an empty cell where you want the total count of sick days to appear (e.g., cell C2).
Type the formula `=COUNTIF(B2:B16,"Sick Leave")` into the selected cell.
Press Enter. The cell will now display the total number of times 'Sick Leave' appears in the specified range.
Explore More
Dynamically Finding Employee Salary by ID
An HR Manager frequently needs to look up an employee's salary based on their unique Employee ID. Manually searching through a large employee roster is inefficient and prone to errors, especially when dealing with hundreds or thousands of employees.
Quickly Locating Employee Email Addresses
An HR manager needs to quickly find an employee's email address to send important announcements, respond to inquiries, or update records, using only their Employee ID. Manually sifting through a large employee roster is inefficient and time-consuming.
Calculate Employee Probation End Date
I need to automatically calculate the date 90 days after an employee's start date to schedule their review.
Find Employee Department by ID (Reverse Search)
I need to look up an employee's department using their ID, but the ID column is to the right of the department column.