DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas to Calculate the Average of a list by Month!!

In this tutorial, we will show the simple formulas used to calculate the average of a list by month in Excel Office 365. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Formulas to calculate the average by month
Formulas to calculate the average by month

General Formula:

  • To calculate the average of a list by month in Excel, use the below formula.

=AVERAGEIFS(values,dates,”>=”&A1,dates,”<=”&EOMONTH(A1))

Syntax Explanations:

  • AVERAGEIFS – This function will return the average of a set of input values that meet the multiple criteria. Read more on the AVERAGEIFS Function.
  • EOMONTH – The EOMONTH Function helps to return the last day of the month after adding/subtracting a specified number of months to a date.
  • Values – It represents the input value from your worksheet.
  • Dates – It represents the input dates.
  • Criteria (A1) – It is the specific criteria that help to calculate the average of the list.
  • Comma symbol (,) – It is a separator which helps to separate a list of values.
  • Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

  • Now we are going to see the formulas to calculate the average by month.
  • Refer to the below image.
  • Here, we will give the input values in Column C and Column D.
  • Then, enter the formula in the selected area.
  • Finally, we will get the result in cell G3.

Example
Example

Wind-Up:

This page described the simple formulas used to calculate the average by month in Excel Office 365. Hope that this article is useful to you. If you have any suggestions, feel free to share it with us. Don’t forget to share your worthwhile feedback in the below comment section. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!

Read Also:

Top comments (0)