COUNTIF / HR Coordinator

Counting Absent Employees for Daily Reporting

An HR Coordinator needs to quickly count the number of employees marked as 'Absent' for the day to provide an accurate daily attendance report to management and ensure proper follow-up.

formula.xlsx
=COUNTIF(B2:B6, "Absent")

How it works: This formula counts the number of cells within the range B2 to B6 (where attendance statuses are listed) that exactly match the text string 'Absent'. The criteria 'Absent' is enclosed in double quotes because it is a text string.

Data Setup

Employee Name Attendance Status
John Doe Present
Jane Smith Absent
Peter Jones Present
Sarah Lee Absent
Mike Brown Present

Step-by-Step Guide

1

Navigate to your daily attendance tracking sheet in Excel.

2

Locate the column that records the 'Attendance Status' for each employee (e.g., Column B).

3

Choose an empty cell where you want to display the total count of absent employees.

4

Enter the formula: `=COUNTIF(B2:B6, "Absent")`.

5

Press Enter to get the total number of absent employees.

Explore More

VLOOKUP

Retrieving Employee Contact Information

As an HR Coordinator, I often need to quickly find an employee's phone number or email address, especially during urgent situations or when updating records. Manually sifting through a large employee roster is inefficient. I need a reliable way to pull specific contact details using their unique Employee ID (e.g., from cell E2).