# How to calculate month-to-date (MTD) sales in Excel

Use SUMIFS from the first of the month to the as-of date: `=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1)`.

**Excel:** `=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| Date | Store | Sales |  | As of | 2026-10-21 |
| 2026-09-28 | Downtown | 2140 |  | MTD sales |  |
| 2026-09-30 | Airport | 1875 |  |  |  |
| 2026-10-01 | Downtown | 2310 |  |  |  |
| 2026-10-06 | Airport | 1690 |  |  |  |
| 2026-10-12 | Downtown | 2045 |  |  |  |
| 2026-10-19 | Airport | 1980 |  |  |  |
| 2026-10-21 | Downtown | 2215 |  |  |  |
| 2026-10-24 | Airport | 1760 |  |  |  |
| 2026-11-02 | Downtown | 2400 |  |  |  |

Formula in F2: `=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1)`

Result: $10,240

## How it works

`EOMONTH(F1,-1)+1` is the first day of the as-of month. The two conditions keep sales from that day through the as-of date, so the September rows and the sales after October 21 are left out.

## Other ways

- `=SUMPRODUCT((A2:A10>=EOMONTH(F1,-1)+1)*(A2:A10<=F1)*C2:C10)`: The same total in any version.
- `=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1,B2:B10,"Downtown")`: Month-to-date for one store: add a condition pair. (Downtown only.)

## Common mistakes

- Without the end condition, future-dated rows such as scheduled orders count toward MTD.
- Typing the month into the formula breaks next month. Build both ends from the as-of date.

## Questions

**How do I compare with the same days last month?**

`=SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-2)+1,A2:A10,"<="&EDATE(F1,-1))`.

**How do I make it update every day?**

Put `=TODAY()` in F1.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/month-to-date-total