» Creating a List in which Each Number is the Sum of the Previous N Numbers
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: We want to create a sequence of numbers where each member of the sequence is the sum of the previous N number of values.
Solution:
Use the SUM, OFFSET, INDIRECT, ADDRESS, ROW, and COLUMN functions as shown in the following formula:
=SUM(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),0,-1,1,-2))
Book Store:
Recommended Books:
- Analyzing Markets, Products, and Marketing Plans
- The Basics of Finance: Financial Tools for Non Financial Managers
- Special Edition Using Microsoft Word 2002
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Microsoft Excel VBA Programming for the Absolute Beginner
No comments have been submitted.
