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 ...
Vlookup Date Picker in Excel (Dynamic)
Tutorial: Make a dynamically updating vlookup date picker for excel that allows you to choose a date...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.