» Summing Annual Expenses by Respective Quarters
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Problem:The range A2:B9 contains a list of dates with corresponding expenses.
We want to create a total of the expenses paid during each quarter.
Solution:
Use the SUM, ROUNDUP, and MONTH functions as shown in the following Array formula:
{=SUM((C2=ROUNDUP(MONTH($A$2:$A$9)/3,0))*$B$2:$B$9)}
Book Store:
Recommended Books:
- Marketing Plans That Work, Targeting Growth and Profitability
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Modeling - 2nd Edition
- Microsoft Office XP Introductory Concepts and Techniques
- Fish! A Remarkable Way to Boost Morale and Improve Results
No comments have been submitted.
