You're an HR analyst pulling weekly attendance metrics for the team huddle. Columns A–F hold a 5-employee × 5-day attendance grid with cells marked Present, Absent, Sick, or Remote.
Your task:
- In column G (Present Days), write a COUNTIF for each employee's row that returns the number of days they were marked "Present" that week.
- The formula must drag-fill from G2 → G6.
Graded cells: G4, G5, G6.
Open this problem on a desktop to attempt it.