PTO Employee Absence and Reason Function

Saneuland

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!

Victoria_Indimar

In your sheet summary:

=SUMIFS({Reference_#ofDays}, {Reference_Employee}, @description, {Reference_Reason}, a$1)

Using this formula, you can then drag and drop to the rest of the cells.