How to Sum by Month in Google Sheets (With Example)


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:

Google Sheets sum by month

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

Leave a Reply

Your email address will not be published.