Hello:
I've posted a document in which I'm trying to calculate the weekly headcount for employees using their timecard entries. There are many entries per week for each employee, but I want to count them only once per week rather than each time they make a timecard entry. Someone on this forum kindly provided the guts for my current formula, but I need to tweak it to deal with one condition that it currently doesn't handle. The person who provided has said he doesn't check in with the forum very often, so I'm putting this out there to a wider audience.
Whenever the value of column W = "UTO" (unpaid time off) I want the formula to ignore that entry (count it as 0 rather than 1) and continue on to the next entry. The way I have the formula now, it counts any "UTO" entries as 0, but then it does not count the subsequent non-UTO entry as 1. I'm not expert enough to fully understand the formula that was provided --(COUNTIFS(B$2:B945,B945,U$2:U945,U945)=1). I have added embedded the formula in an IF statement to ignore the "UTO" entries.
=IF([@[Util?]]="UTO",0,--(COUNTIFS(B$2:B945,B945,U$2:U945,U945)=1)) ("Util?" is the header for column W)
Many thanks in advance for your help!
Bookmarks