» Summing the Last N Values in a Column
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Calculating the sum of the last n numbers in List1 (column A) for each value of N in column B.
Solution:
Use the SUM, OFFSET, and COUNTA functions as shown in the following formula:
=SUM(OFFSET($A$2,COUNTA($A$2:$A$7)-1,0,-B2))
Book Store:
Recommended Books:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The New Financial Order: Risk in the Twenty-First Century
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Guide to Financial Reporting and Analysis
No comments have been submitted.
