Use COUNTA() Formula

I need to track employee attendance. How can I use the COUNTA() formula to count the number of days an employee is present in a month?

You can use the COUNTA() formula like this

COUNTA({Attendance}, “Present”)

This formula counts the number of days an employee is “Present.”