» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
