Table of Contents
In order to calculate the sum by month in Google Sheets, a formula can be created using the SUMIFS function with the criteria of specific dates falling within a certain month. For example, the formula would look like this: =SUMIFS(range of values, range of dates, “>=”&DATE(year, month, 1), range of dates, “
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:
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:
Cite this article
stats writer (2024). How can I create a formula to calculate the sum by month in Google Sheets, using an example?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-create-a-formula-to-calculate-the-sum-by-month-in-google-sheets-using-an-example/
stats writer. "How can I create a formula to calculate the sum by month in Google Sheets, using an example?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-create-a-formula-to-calculate-the-sum-by-month-in-google-sheets-using-an-example/.
stats writer. "How can I create a formula to calculate the sum by month in Google Sheets, using an example?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-create-a-formula-to-calculate-the-sum-by-month-in-google-sheets-using-an-example/.
stats writer (2024) 'How can I create a formula to calculate the sum by month in Google Sheets, using an example?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-create-a-formula-to-calculate-the-sum-by-month-in-google-sheets-using-an-example/.
[1] stats writer, "How can I create a formula to calculate the sum by month in Google Sheets, using an example?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I create a formula to calculate the sum by month in Google Sheets, using an example?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.