question

JoeKnowes-8225 avatar image
0 Votes"
JoeKnowes-8225 asked emilyhua-msft commented

SUMIFs from the Employee Attendance Record Template

From the Employee Attendance Template I downloaded for Excel, I have the following cells in the Calendar View Sheet:
198006-image.png



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.

office-excel-itpro
image.png (8.4 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @JoeKnowes-8225

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".


0 Votes 0 ·

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

0 Votes 0 ·

0 Answers