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
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.
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 !!
Top comments (0)