Excel 2016 (Windows) 32 bit
E
F
5
 Quantity
6
 Q1
113761
7
 Q2
62966



E
F
5
 Quantity
6
 Q1
=SUMIFS($B:$B,$C:$C,">="&DATEVALUE("01/01/2020"),$C:$C,"<"&DATEVALUE("01/04/2020"))
7
 Q2
=SUMIFS($B:$B,$C:$C,">="&DATEVALUE("01/04/2020"),$C:$C,"<"&DATEVALUE("01/07/2020"))
Sheet: Sheet1