Be it for budgeting, reporting, or analysis, you can easily sum data within a date range using the SUMIFS formula. SUMIFS is an extended form of SUMIF formula where you can enter multiple criteria.

Syntax

=SUMIFS(values to sum range, date range, >=minimum date, date range, <=minimum range)

Steps

  1. Type =SUMIFS(
  2. Select or type range reference that includes cells to add $H$3:$H$10
  3. Select or type range reference that includes date values you want to apply the criteria against $C$3:$C$10
  4. Type minimum date criteria with equoal or greater than operator “>=1/1/2010”
  5. Add the date range again $C$3:$C$10
  6. Type maximum date criteria with equal or greater than operator “>=1/1/2010”
  7. Type ) and press Enter to complete formula

How

SUMIFS function adds values that meet single or multiple criteria. Ability to use criteria with logical operators like greater than or equal (>=) and less than or equal (<=) provides the way of adding values between values.

To filter dates between two dates, we need two criteria and suitable operators. We used “>=1/1/2010” and “<=12/31/2012” criteria to define start and end dates of searching. Search is made on same date range $C$3:$C$10.

=SUMIFS($H$3:$H$10,$C$3:$C$10,”>=1/1/2010″,$C$3:$C$10,”<=12/31/2012″)

Tip: Order of dates do NOT matter. “<=12/31/2012” criteria can be placed as first criteria.

Alternative way to write formula is using cell references instead of static dates. For example; if your minimum date value is at cell K8, then criteria would be written as “>=”&K8.

=SUMIFS($H$3:$H$10,$C$3:$C$10,”>=”&K8,$C$3:$C$10,”<= “&K9)