SUMIFS challenge
Your goal: Sum between two dates and include the whole end day.
Sum between two dates and include the whole end dayClick cells to select C2:C10 and B2:B10 and E2 and E3
| # | |||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 | |||||
| 8 | |||||
| 9 | |||||
| 10 |
Find the input cells
Select C2:C10 and B2:B10 and E2 and E3 in the table, then choose Check inputs. Selected cells change color.
SUMIFS parameters
SUMIFS(sum_range, criteria_range1, criteria1, [criteriaRange2], [criteria2])
The range of cells to sum.
- In this example
C2:C10- Where it comes from
- Reads the following cells in the displayed worksheet.
C2:C10— Column C (Amount), rows 2–10.