PTO Employee Absence and Reason Function

Good morning,

I have created a spread sheet listing the employees and their reason for absence. I would like to make sheet summary to account for each employee and their reasons - so for instance...

Team Member: Sarah

Type of Absence: Appointment (there is a drop down list of reasons)

#Days : 1

What function would I use in order to count each reference to Sarah accounting for the type of absence and the number of days.

If easier - What function would I use to account for Sarah and the total number of days column?

Thank you for any help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!