Answer actually depends on the version of Excel you're using. I think SUMIFS was added in 2007, but it might be 2010, so this may not work for you. If not, we'll reach to SUMPRODUCT instead.
Assumptions:
Start Date is in K2
End Date is in K3
Auditor is in K4
Formula: =COUNTIFS(B2:B2867,K4,C2:C2867,">="&K2,C2:C2867,"<="&K3)
Oh.. and there actually only appear to be 2 instances of Derek Spencer in that range.![]()
Bookmarks