Then:
![]()
=SUMIFS('Transaction DB'!$E:$E,'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)+TIME(23,59,59),'Transaction DB'!$D:$D,B41)
Bookmarks