Oct 02 2020 02:49 PM
Oct 02 2020 10:58 PM
@Peteeyres ,,,
I would like to suggest two possible formula/function:
=SUMPRODUCT(--(A2:A25>=DATE(2020,9,1))*(A2:A25<=DATE(2020,9,30))*(D2:D25))
=SUMIFS(D2:D25,A2:A25,">=09/01/2020",A2:A25,"<=09/30/2020")