» Summing the Last N Values in a Column
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Investing in Real Estate, Fourth Edition
- Marketing Plan: A Handbook with Marketing Plan
- Microsoft Access Version 2002 Step by Step
- Guide to Financial Reporting and Analysis
No comments have been submitted.


