I'm also learning the index and match functions.
I'm trying to build a formula that searches expenses by date and returns the sum of values only during that month.
This way I can have an endless expenses sheet and my monthly P&L searches for expenses that only occurred during that month.
I have attached sample data. This same formula could ultimately be used for income too.
Bookmarks