» 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:
- PowerPoint® 2002 For Dummies®
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Advanced modelling in finance using Excel and VBA
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
