How to Sum by Months in Google Sheets ( Quick & Easy Guide )

In this tutorial, you will learn How to Sum by Months in Google Sheets

  • To Sum by Months in Google Sheets you can first extract the dates using the Month() function from your dataset then from the result identify the unique months.
  • Once the Unique months are identified. You can use the SUMIF function to get the SUM by Months in Google Sheets

How to Sum by Months in Google Sheets: Step by Step Guide

Enclosed are the steps on How to Sum by Months in Google Sheets

Step 1: Prepare your dataset

Below is the dataset which we will use to sum by Months in Google Sheets

The following dataset consists of Dates and Visa Applications on that day

Step 2: Use the Month() function to extract Months from dates

Now we will use the Month function to extract the Months from the available dates in our data set

Below is the formula which we will use in our example. We will type =Month(A2) in the cell D2

=MONTH(A2)
17-09-2022 (Part-2) | Yearly Income...
17-09-2022 (Part-2) | Yearly Income Software | Make Money Online

To get the result on the rest of the cells in Column D . Move the cursor on top of the blue pointer in Cell D2 until it turns into a plus sign and starts dragging it downwards to apply the formula to the rest of the cells.

Step 3: Identify the Unique Months

Now we will identify the Uniques Months from the previous result using the  =UNIQUE() function

We will type the formula =UNIQUE(D2:D11) in Cell E2 in our example

=UNIQUE(D2:D11)

Once we press enter we get a list of Unique Months

Step 4: Use the SUMIF function to find the Sum by Months

Now to find the Sum by Months we will use the SUMIF(range, criterion, sum_range) function to calculate the sum of visa applications in each month

We will type the below formula in Cell F2 in our example

In our example, we’ll type the following formula in cell F2:

=SUMIF($D$2:$D$11, F2, $B$2:$B$11)

Complete the suggested Auto-fill to apply the formula to the rest of the cells

How to Sum by Months in Google Sheets

Now we have the total number of applications as shown below

The above result means :

  • The total number of Visa applications in January was 87
  • The total number of Visa applications in February was 33
  • The total number of Visa applications in April was 27

Similarly, we can interpret the other results.

How to Sum by Months in Google Sheets(Conclusion)

In the above tutorial, we have shown you steps using which you Sum by Months in Google Sheets. We hope this tutorial on How to Sum by Months in Google Sheets was useful

Related articles :

How to Insert Spin Button in Google Sheets ( Easy Guide )

How to Freeze Rows in Google Sheets

How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)

How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )