Excel Forum
Similar Content
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Years, Months, Days Between two dates in Excel
Tutorial: I have found a rather convoluted method to Calculate the Number of Years, Months and Days ...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...

Excel Magic Trick #183: Income Statement by Year & Month

See how to sum revenue from a table of data by year and month using the SUMPRODUCT & TEXT & SUM & IF & LEFT functions in an array formula.
SUM items based on Two Conditions. SUM items based on two criteria. SUM items based on multiple conditions criteria.
Also see these videos:
YouTubersLoveExcel#45: SUMPRODUCT & TEXT functions
YTL Excel #130: Income Statement from Excel Table: Array For

Got a Question? Ask it Here in the Forum.