Excel Forum
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 #506: Summarize Data - Multiple Sheets & Banks Accounts - Checkbook Register


Take Checkbook Register data from multiple sheets and for multiple banks accounts and summarize it based on Account Names. See these tricks:
1.Formula to display different chart of accounts for different companies
2.Formula to summarize account data from different sheets and for different banks accounts
3.Dynamic Formulas that choose different Chart Of Accounts and Different Calculations using the amazing CHOOSE function.
4.See how to use SUMIF to add from some worksheets but not others.
5.See the functions IF, ROWS, COUNTA, CHOOSE, VLOOKUP, INDEX, SUMIF
6.Create Names From Selection
7.Data Validation List
8.Dynamic Ranges using Table / List feature





Got a Question? Ask it Here in the Forum.