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.
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.