» Summing Expenses Accumulated to a Specified Month
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
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:
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Special Edition Using Microsoft Excel 2002
- Personal Finance for Dummies
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Access 2002 for Dummies
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
