Table of Contents
To calculate the average of a set of data in Google Sheets within a specific date range, you can use the AVERAGEIFS function. This function allows you to specify the range of cells to be averaged, as well as the criteria for the dates falling within the desired range. Simply enter the AVERAGEIFS formula into a cell, specify the range of data and the date range criteria, and press enter to get the average value. This method can be useful for analyzing data within a specific time frame, such as monthly or yearly averages.
Google Sheets: Calculate Average If Between Two Dates
You can use the following formula to calculate the average in Google Sheets only for cells that fall between two specific dates:
=AVERAGEIFS(B2:B11, A2:A11, "<=1/15/2022", A2:A11, ">=1/5/2022")
This particular formula calculates the average value of cells in range B2:B11 where the date in the range A2:A11 is between 1/5/2022 and 1/15/2022.
The following example show how to use this formula in practice.
Example: Calculate Average If Between Two Dates
Suppose we have the following dataset that shows the total sales made by some company on various dates:
We can use the following formula to calculate the average daily sales between 1/5/2022 and 1/15/2022:
=AVERAGEIFS(B2:B11, A2:A11, "<=1/15/2022", A2:A11, ">=1/5/2022")
The following screenshot shows how to use this formula in practice:
The average daily sales between 1/5/2022 and 1/15/2022 is 7.2.
We can manually verify that this is correct:
Average Daily Sales = (7 + 7 + 8 + 6 + 8) / 5 = 7.2.
Note: You can find the complete documentation for the AVERAGEIFS function .
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-of-a-set-of-data-in-google-sheets-if-the-values-fall-between-two-specific-dates/
stats writer. "How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-of-a-set-of-data-in-google-sheets-if-the-values-fall-between-two-specific-dates/.
stats writer. "How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-of-a-set-of-data-in-google-sheets-if-the-values-fall-between-two-specific-dates/.
stats writer (2024) 'How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-calculate-the-average-of-a-set-of-data-in-google-sheets-if-the-values-fall-between-two-specific-dates/.
[1] stats writer, "How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I calculate the average of a set of data in Google Sheets if the values fall between two specific dates?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.