## Explanation

The SUMIFS function allows logical operators (i.e. "=",">",">=", etc.), and can handle multiple criteria. To target values between two dates, we need to use two criteria, each entered as a criteria/range pair like this:

```
">"&H5,date // greater than H5
"<"&H6,date // less than H6
```

Note we need to enclose the logical operators in double quotes (""), then concatenate them to cell references with the ampersand (&). This is because SUMIFS is in a group of functions with unique syntax for criteria.

The final formula looks like this:

```
=SUMIFS(amount,date,">"&H5,date,"<"&H6)
```

where **date** (C5:C11) and **amount** (D5:D11) are named ranges. Note this formula *does not* include values on the start or end date in the result, only values *between* these dates. To include start and end dates, use greater than or equal to (>=) and less than or equal to (<=).

### With hard-coded dates

The best way to hard-code dates into the SUMIFS function is to use the DATE function. For example, to sum values in **rng1** between July 1, 2020 and September 30, 2020, you can use a formula like this:

```
=SUMIFS(rng1,rng2,">="&DATE(2020,7,1),rng2,"<="&DATE(2020,9,30))
```

Notice this formula uses greater than or equal to (">=") and less than or equal to ("<=") to *include* the start and end date in the final result.

### Adding more criteria

To extend the formula to apply more criteria, just add another range/criteria pair. For example, the formula below will sum values in **rng1** when dates in **rng2** are between dates in A1 and B1, AND values in **rng3** are equal to C1:

```
=SUMIFS(rng1,rng2,">"&A1,rng2,"<"&B1, rng3, C1)
```