Select Page

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)