Using the versatile SUMIF function, see how you can create cell totals from a certain date. Creating a YTD (year-to-date) reports has never been easier.

Syntax

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

=SUMIF(date range, >minimum date, values to sum 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 greater than operator “>1/1/2010”
  5. Type ) and press Enter to complete formula

Note: When using SUMIF, follow steps according to syntax of SUMIF.

How

Both functions can be used to add values that meet a criteria. They search a given criteria in a criteria range, this processes result is an array of TRUE/FALSE. Ability to use criteria with logical operators like greater than (>) provides the way of adding values between values.

We used “>1/1/2010” criteria to define minimum date and search is made on date range $C$3:$C$10.

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

=SUMIF($C$3:$C$10,”>1/1/2010″,$H$3:$H$10)

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

=SUMIFS($H$3:$H$10,$C$3:$C$10,”>”&$K$9)

=SUMIF($C$3:$C$10,”>”&$K$9,$H$3:$H$10)