Skip to content

Sum values for a given month

Total everything dated in the same month as a date you choose.

The formula

Argument separator
Excel and Google Sheets
=SUMIFS(C2:C100, A2:A100, ">="&F1, A2:A100, "<="&EOMONTH(F1, 0))

How it works

  1. ">="&F1

    Dates on or after the first day of the month in F1 (for example 1 March 2026).

  2. "<="&EOMONTH(F1, 0)

    Dates on or before the last day of that month.

  3. C2:C100

    The amounts to add up.

Example

A: DateC: Amount
2026-03-02100
2026-03-2840
2026-04-0175

Tips

  • With F1 = 2026-03-01, the result is 140.
  • If your dates include times, use "<"&EOMONTH(F1, 0)+1 for the end condition.