Should I use Sumifs or Sum product.

BTW, if there is "over midnight" counted, date and time range must be combinated by SUMPRODUCT, like this:
=SUMPRODUCT((date_range+time_range>=date1+time1)*(date_range+time_range<=date2+time2)*value_range)