Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...
FILTER() Function Excel - Power Lookup for the Future
Tutorial: The new FILTER() function for Excel 365 allows you to do amazing things with a single sim...
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




YTL Excel #130: Income Statement from Excel Table: Array For


See how to create a small business Income Statement from an Excel Table using an array formula. See how to use Custom Number Formatting (format). See how to use the SUM, MONTH, LEFT and IF functions to create this array formula for retrieving Revenues and Expenses form an Excel Table.





Got a Question? Ask it Here in the Forum.