Sumproduct by month

---

Back in April of 2018, I published a blog post on how to organize monthly data into quarters. Today I will demonstrate how to  group data that is not organized based on dates, into months.

Consider the data set below containing a list of dates in the last column. 

​Here is a formula for doing so for the month of January.

=SUMPRODUCT((MONTH(Date)=1)*OrderAmount)

This formula bascially identifies all dates that belong to the month of January (i.e. (MONTH(Date)=1)) and then provides the sum of all order amounts belonging to that month

In order to create this formula, I first created two named ranges:

Date: containing data in column C (i.e. range: C2:C90 in my dataset)
OrderAmount: Containing  data in column B (i.e. range: B2:B90 in my dataset)

Here us the formula applied for all 12 months. Note that the reference (Month(Date)=1 ) needs to be incremented for each month. e.g. "2" for February.

---