Excel Forum

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.