Need Help Counting Specific Times In Filtered Table

Hello,

I have a table of phone calls that includes a duration in (h):mm:ss format. At the top of the table is a dashboard that shows total calls, unique calls, etc... I also need to show calls that fall below 30 seconds, between 30 seconds and 59 seconds, and above 1 minute. This needs to change appropriately if a filter is applied (e.g., a specific number or source). Here is what I have so far for calls below 30 seconds:

=SUMPRODUCT(SUBTOTAL(103,OFFSET(A1,ROW(E19:E5018)-ROW(A1),0)),--(E19:E5019<"00:30"))

It returns the #VALUE and no amount of tweaking on my part has been able to get a correct return that changes when filtered.

I have attached a sample workbook. Basically, I need to count the calls below 30 seconds. The time duration is in column D (it was column E, but I removed a column for privacy purposes). I need the calculation in L13 to change if the data is filtered on any row.

Any and all help is appreciated!