Hello,
I'm trying to build a formula that searches a list of expenses by date and returns only the sum of values that occurred during that month.
Column C holds the dates and Column E holds their respective expense. The months tab is where I would like to display the summary of expenses. Is there a way to write an Index / match formula without building a date range for each month?
I was able to write an if then formula that solved my problem however manipulating it for each month and each expense was annoying.
Bookmarks