Sum formula for the last 30 days

[ExcelLearner00]

I'm looking for perhaps an offset formula that will help me count the number of times in the past 30 days someone has taken a break over 27 minutes in the past 30 days. I already have a conditional format to show the last 30 days.

 

[Hui]

For the Less than 27 day total
=SUMPRODUCT(($D$3:$BR$37<27)*($D$2:$BR$2>TODAY()-30)*($D$2:$BR$2<=TODAY()))

For the Greater than 27 day total
=SUMPRODUCT(($D$3:$BR$37>27)*($D$2:$BR$2>TODAY()-30)*($D$2:$BR$2<=TODAY()))

For the Equal 27 day total
=SUMPRODUCT(($D$3:$BR$37=27)*($D$2:$BR$2>TODAY()-30)*($D$2:$BR$2<=TODAY()))

For no break
=SUMPRODUCT(($D$3:$BR$37=0)*($D$2:$BR$2>TODAY()-30)*($D$2:$BR$2<=TODAY()))

You didn't specify the report date so I used Today()

You can adjust to suit