» Summing Expenses Accumulated to a Specified Month
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Column B contains the expenses for each of the months January to July.
We want to create a formula that will sum the expenses for all the months between January and the month specified in cell D2.
Solution:
Use the SUM, OFFSET, and MATCH functions as shown in the following formula:
=SUM(OFFSET(B2,0,0,MATCH(D2,A2:A8,0),1))
Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Investing in Real Estate, Fourth Edition
- The One Page Business Plan: Start With a Vision, Build a Company!
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Microsoft Windows XP Registry Guide
No comments have been submitted.
