In this tutorial, we will describe the simple formulas used to sum the values from the last N columns 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 formula to sum the values from the last N columns in Excel.
=SUM(INDEX(data,0,COLUMNS(data)-(n-1)):INDEX(data,0,COLUMNS(data)))
Syntax Explanations:
- SUM -In Excel, the SUM Function adds values in the cells.
- INDEX – This function returns the value at a given position in a range or array. Read more on the INDEX Function.
- COLUMNS – The Excel** COLUMNS function** helps to return the count of columns in a given reference.
- Data – It represents the input range given in the 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.
- Minus Operator (-) – This symbol will help to subtract any two values.
Example:
- Let’s consider the below image, to sum the last n columns.
- Here, we will give the input values from Column C to Column G.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the result in Cell J3.
Closure:
From this tutorial, you can get some clarification on the formulas used to sum the values from the last N columns in Excel Office 365. Hope you like this article. If you have any suggestions, don’t forget to share it with us. Thank you so much for Reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)