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!
