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!
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!