# How to sum values by date in Excel

List each date once and use SUMIF against the date column: `=SUMIF($A$2:$A$9,E2,$C$2:$C$9)`, filled down.

**Excel:** `=SUMIF($A$2:$A$9,E2,$C$2:$C$9)` (Every current version)

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

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| Date | Order | Amount |  | Date | Daily total |
| 2026-04-06 | SO-201 | 125 |  | 2026-04-06 |  |
| 2026-04-06 | SO-202 | 89.5 |  | 2026-04-07 |  |
| 2026-04-07 | SO-203 | 240 |  | 2026-04-08 |  |
| 2026-04-06 | SO-204 | 62.25 |  |  |  |
| 2026-04-08 | SO-205 | 310 |  |  |  |
| 2026-04-07 | SO-206 | 47.8 |  |  |  |
| 2026-04-08 | SO-207 | 198.4 |  |  |  |
| 2026-04-08 | SO-208 | 75 |  |  |  |

Formula in F2, filled to F4: `=SUMIF($A$2:$A$9,E2,$C$2:$C$9)`

Result: $276.75; $287.80; $583.40

## How it works

Dates are whole numbers underneath, so SUMIF can match a date exactly like any other value. Each row of the summary adds every order with that date, in any order in the list. The `$` signs keep the data ranges in place while `E2` moves down.

## Other ways

- `=SUMIFS($C$2:$C$9,$A$2:$A$9,E2)`: SUMIFS puts the sum range first, ready for more conditions such as a region.

## Common mistakes

- If the dates include times (4/6/2026 9:15), no row equals the plain date and the total is 0. Use a one-day window: `=SUMIFS($C$2:$C$9,$A$2:$A$9,">="&E2,$A$2:$A$9,"<"&E2+1)`.
- Dates imported as text don't match real dates. Check that both columns are right-aligned or use DATEVALUE.

## Questions

**How do I list each date once automatically?**

In Excel 365 or Google Sheets: `=SORT(UNIQUE(A2:A9))`, then point SUMIF at the spilled list.

**How do I sum the dates in one week or month?**

Use a date window with SUMIFS; see summing by week and by month.

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/sum-by-date