» Summing Annual Expenses by Respective Quarters
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
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:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.


