Often you may want to sum the values of some dataset in Google Sheets based on month.
The following step-by-step example shows how to do so.
Step 1: Enter the Data
First, enter the values for a dataset that show the total sales of some product on various dates:
Step 2: Extract the Month from Dates
Next, we need to use the =MONTH() function to extract the month from each date.
In our example, we’ll type the following formula in cell D2:
=MONTH(A2)
We’ll then drag and fill this formula down to every remaining cell in column D:
Step 3: Find the Unique Months
Next, we need to use the =UNIQUE() function to produce a list of unique months.
In our example, we’ll type the following formula in cell F2:
=UNIQUE(D2:D10)
This will produce a list of unique months:
Step 4: Find the Sum by Month
Next, we will use the SUMIF(range, criterion, sum_range) function to find the sum of the sales made during each month.
In our example, we’ll type the following formula in cell G2:
=SUMIF($D$2:$D$10, F2, $B$2:$B$10)
We’ll then drag and fill this formula down to the remaining cells in column G:
This tells us:
- There were 117 total sales made in January.
- There were 50 total sales made in February.
- There were 111 total sales made in March.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
How to Calculate a Five Number Summary in Google Sheets
How to Use SUMIF Contains in Google Sheets