=SUMPRODUCT(--('Transaction DB'!$J:$J>=DATE('Set Date'!$D$2,'Set Date'!$B$2,'Set Date'!$C$2)),--('Transaction DB'!$J:$J<=DATE('Set Date'!$D$4,'Set Date'!$B$4,'Set Date'!$C$4,23:59:59)),--('Transaction DB'!$D:$D=B41),'Transaction DB'!$E:$E)
Since it should default to 0:00:00 for the start date I don't need to add a start time. But would the above for End Time be correct?