FORMULA & SQL / TOTALS
Total between two dates.
Tested, not guessed.
The Excel and Google Sheets formula and the SQL query, each run on the rows below. Open this with your own data ↗
The example rows
| Row | A: Region | B: Rep | C: Amount | D: Order Date | E: Status | F: Customer |
|---|---|---|---|---|---|---|
| 2 | North | Ana | 1,200 | 2026-03-01 | Paid | Jo Smith |
| 3 | South | Ben | 450 | 2026-03-15 | Open | Raj Patel |
| 4 | North | Cy | 300 | 2026-04-02 | Paid | Lee Wong |
| 5 | East | Ana | 980.50 | 2026-04-20 | Paid | Mia Ross |
| 6 | North | Ben | 75 | 2026-05-05 | Open | Jo Smith |
| 7 | West | Dee | 1,640 | 2026-05-18 | Paid | Sam Okoro |
The formula
Excel
=SUMIFS(C:C,D:D,">="&DATE(2026,1,1),D:D,"<="&DATE(2026,3,31))
The total of the Amount column (C:C) where the Order Date column (D:D) is at least DATE(2026, 1, 1) — which builds a date from year, month and day and the Order Date column (D:D) is at most DATE(2026, 3, 31) — which builds a date from year, month and day.
Run on the example rows:
Result1650
The SQL
PostgreSQL
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
Run on the example rows:
| total |
|---|
| 1650 |
Other databases
MySQL
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
SQL Server
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
SQLite
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
BigQuery
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
Snowflake
SELECT SUM(amount) AS total FROM sales WHERE order_date BETWEEN '2026-01-01' AND '2026-03-31'
Your own data
Paste your rows into the free tool and it writes this for your columns, then runs it on your data before you copy it. Open the tool ↗