» 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Microsoft Excel VBA Programming for the Absolute Beginner
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Windows XP Registry Guide
- The 11 Immutable Laws of Internet Branding
No comments have been submitted.
