# Sum by month in Excel and Google Sheets

=SUMIFS(B2:B5,A2:A5,">="&D5,A2:A5,"<="&EOMONTH(D5,0))

• ### "<="&EOMONTH(D5,0) = criteria_range2 condition.

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

# Sum by month in Excel

How to sum by month in Excel?

# SUM BY MONTH — EXCEL FORMULA AND EXAMPLE

=SUMIFS(B2:B5,A2:A5,">="&C6,A2:A5,"<="&EOMONTH(C6,0))

• B2:B5 = sum range

• A2:A5 = criteria_range1

• ">="&C6 = criteria_range1 condition.

• A2:A5 = criteria_range2

• "<="&EOMONTH(C6,0) = criteria_range2 condition.

• EOMONTH function will return the end date of the selected month. In this example 31st of March 2021.

# Sum by month in Google Sheets

How to sum by month in Google Sheets?

# SUM BY MONTH — GOOGLE SHEETS FORMULA AND EXAMPLE

=SUMIFS(B2:B5,A2:A5,">="&D5,A2:A5,"<="&EOMONTH(D5,0))

• B2:B5 = sum range

• A2:A5 = criteria_range1

• ">="&D5 = criteria_range1 condition.

• A2:A5 = criteria_range2

• "<="&EOMONTH(D5,0) = criteria_range2 condition.

• EOMONTH function will return the end date of the selected month. In this example 31st of March 2021.