SUMIFs from the Employee Attendance Record Template

Joe Knowes 6

From the Employee Attendance Template I downloaded for Excel, I have the following cells in the Calendar View Sheet:

The cell "Days on Leave" show the following formula:
=SUMIFS(LeaveTracker[Days],LeaveTracker[Employee Name],valSelEmployee,LeaveTracker[Start Date],">="&DATE(Calendar_Year,1,1),LeaveTracker[End Date],"<"&DATE(Calendar_Year+1,1,1))

This sums up all the Leaves Recorded across "OB earned", "OB used", "SIL used", and "Sick/Vacation".

How do I modify the formula to only show sums for "OB used", "SIL used", and "Sick/Vacation"?
I appreciate any answers. Thanks.

Emily Hua-MSFT 27,526 Reputation points

2022-05-02T07:57:53.037+00:00
Hi @Joe Knowes

Welcome to Q&A fourm ~

> How do I modify the formula to only show sums for "OB used", "SIL used", and "Sick/Vacation"?

But as I am confused about the blue square with "4" for "OB Earned", the orange square with "0" for "OB used", the green square with "5" for "SIL" and yellow square with "0" for "Sick/Vacation".
Do these numbers's sum mean the "Days on Leave"? Since 9=4+0+5+0.

If yes, you can subtract "OB Earned" from the total sums.

But if not, please share us with a simple sample for better analysis.
We can calculate the number of days for "OB earned", then subtract it from total sums; or we use the sumifs function to add only "OB used", "SIL used", and "Sick/Vacation".
Emily Hua-MSFT 27,526 Reputation points

2022-05-05T01:43:09.403+00:00

Hi @Joe Knowes
I am checking this thread, is there any update?
If yes, please feel free to post back.

1 answer

Nichole Jones 0 Reputation points

2023-01-24T23:20:21.0833333+00:00

I am having such a hard time adding a fifth type of leave. I can't seem to get it to compute on the employee leave tracker even though I have added the appropriate columns.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment