How to sum values by month in Excel and Google Sheets

Excel & Google Sheets

=SUMIFS(B:B, A:A, ">="&DATE(2026,1,1), A:A, "<"&DATE(2026,2,1))

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Formula

Runs server-side · free · no signup

1B:B is the column to total; A:A holds the dates.
2The first condition keeps rows on or after the 1st of the month.
3The second keeps rows before the 1st of the next month — together that is exactly one month.

Use EOMONTH to build the bounds dynamically from a single date cell.
A helper column =TEXT(A2, "yyyy-mm") plus SUMIF is an easy alternative for grouping by month.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

SUMIFS criteria can’t call MONTH() on the range. Use date bounds (>= start, < next month), or add a helper column with the month and SUMIF on that.

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026