Sum between dates

For values to be sum between dates, use the SUMIFS function. For between dates, we will need two criteria to match dates, in our example, we will sum all values between “1-Jan-20” to “28-Feb-20”.

The SUMIFS function used in our example is:

=SUMIFS(B5:B9,A5:A9,”>=”&A13,A5:A9,”<=”&B13) where,

sum_range (B5:B9) – The range of cells to sum against both criteria of dates,

criteria_range1 (A5:A9) – The range of cells that will be tested against criteria1.

criteria1 (“>=”&A13) – The criteria to sum only those dates which are either equal to or greater than “1-Jan-20”,

criteria_range2 (A5:A9) – The range of cells that will be tested against criteria2,

criteria2 “<=”&B13 – The 2nd criteria to sum only those dates which are either equal to or less than “28-Feb-20”.

Result:

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved