DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas to Calculate the Average of Last N Values!!

This page will show the simple formulas used to calculate the Average of last N values in Excel Office 365. Let’s get started!! 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 of last N values
Formulas to calculate the average of last N values

General Formula:

  • Use the below image to calculate the average of the last N values in Excel.

=AVERAGE(OFFSET(A1,COUNT(A:A),0,-N))

Syntax Explanations:

  • AVERAGE – This function returns the arithmetic mean of given input numbers. Read more on the AVERAGE Function.
  • OFFSET – In Excel, this function will return a reference to a range constructed in parts which is a starting point, a row, and column offset, and a final height and width in rows and columns. Read more on the OFFSET Function.
  • COUNT – The Excel COUNT Function will count the number of cells that contain numbers and returns the output in number.
  • Range – It represents the input value from your worksheet.
  • 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:

  • In the below example image, we will give the input values in Column C.
  • Then, enter the given formula in the formula bar section.
  • Finally, we will get the result in cell F3.

Example
Example

Conclusion:

Here, we explained you to learn the simple formulas used to calculate the last N values in Excel Office 365. Hope that this article is useful to you. If you have any doubts/queries, feel free to share it with us. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!

Read Ahead:

Top comments (0)