Excel Formulas to find Average last N values in a table in Excel!!

In this tutorial, we are going to look at how to find the average last N values in a table in Excel Office 365. We will show you the easy steps for completing the task quickly. Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula

• You can use the below-mentioned formula to find the averagelast N values in a table in Excel.

=[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(table[column],[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(table)-(N-1)):[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(table[column],[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(table)))

Syntax Explanation

• COLUMN ** – This function is used to return column numbers for reference. Read more on the **COLUMN Function.
• *ROWS *– This function returns the count of rows in a given reference.
• INDEX ** – The **INDEX function returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function.
• Minus Operator (-) – This symbol will help to subtract any two values.
• Parenthesis () – The main purpose of this symbol is to group the elements.
• AVERAGE – This function returns the arithmetic mean of given input numbers.

Practical Example

To find the average last N values in a table, refer to the below given example.

• For instance, you have to create a sample data in Excel.

Sample data

• To calculate the average for the last N values in an Excel table, you need to use the following formula in the formula bar.

=[AVERAGE](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)([INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table1[Sales],[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(Table1)-(F4-1)):[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Table1[Sales],[ROWS](https://geekexcel.com/use-rows-function-in-microsoft-excel-365-simple-methods/)(Table1)))

Use the Formula

• Now, you will get the result as given below in the cell F5.

Output

Closure

In this tutorial, we guided you to know how to find the average last N values in a table in Excel Office 365 with proper examples and screenshots. Kindly, give your feedback in the below comment section.

Thanks for visiting Geek Excel!! *If you want to learn more helpful formulas, check out Excel Formulas *!!

Continue Reading:

• Excel Formulas to Find Lowest N Values ~ Complete Tutorial!!
• Use Excel N Function in Office 365 -Simple methods!!
• Formulas to Sum the Lowest N values from a Range in Excel!!
• Excel Formulas to Sum the Top N Values ~ Simple Guide!!
• Excel Formulas to Find the Last N Rows ~ Useful Tutorial!!