# Independent SUMIFS answer check

Question: **Software spend in September 2026**. The date window includes **September 1** and excludes **October 1**.

| Date | Category | Amount (USD) | Included? |
| --- | --- | ---: | --- |
| Sep 1 | Software | 24 | Yes |
| Sep 4 | Hosting | 40 | No: other category |
| Sep 12 | Software | 36 | Yes |
| Sep 30 | Software | 15 | Yes |
| Oct 1 | Software | 99 | No: next month |
| Aug 31 | Software | 88 | No: previous month |
| Sep 9 | Office | 12 | No: other category |
| Sep 17 | Hosting | 20 | No: other category |

**Expected Software total:** 24 + 36 + 15 = **$75**.

**Boundary checks:** All Software rows, ignoring dates, sum to $262. All September rows, ignoring categories, sum to $147. September Hosting totals $60. These totals are calculated directly from the eight-row source list, independently of the Sheets formula.

Formula for English-US syntax, assuming the paste starts in A1:

```excel
=SUMIFS(C2:C9,B2:B9,"Software",A2:A9,">="&DATE(2026,9,1),A2:A9,"<"&DATE(2026,10,1))
```

The video's result is an expected mathematical result, not a claimed live Sheets calculation. Verify numeric dates and the formula in a disposable Sheet.