Hi Vanessa,

Am Thu, 29 Mar 2018 17:02:46 +0100 schrieb Vanessa Sales:

I need to count how many times in the last 30 days an employee has
worked more than 12 hours.

I have it so that A3:A308 are dates (3/1/2018 through 12/31/2018) and
the employee names are listed in the first row (just to test it out I'm
using B1 through P1). Row 2 is where i want to insert the formula.

So for B3 through B308, I will enter number of hours worked each of
those days.

try in B2:
=SUMPRODUCT(--($A$3:$A$308=TODAY()-30),--($A$3:$A$308<=TODAY()),--(B$3:B$308=12))
and copy to the right.


Regards
Claus B.
--
Windows10
Office 2016