I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works:
=SUMIFS({Expense Collector Range 4}, {Expense Collector Range 1}, "Groceries", {Expense Collector Range 5}, >=DATE(2025, 11, 1), {Expense Collector Range 5}, <=DATE(2025, 11, 30))
Here is my problem. There are MANY different expense categories for this sheet and I want this sheet to be easy to edit for future years without having to edit every forumla's date. So I build a table of dates and want the formula to simply reference that table, and then I can change the dates on the table and all formula's in sheet will update. I have done this in the past but i don't know what i'm doing wrong now and don't have access to the old sheet. i keep getting an #INCORRECT ARGUMENT error. Here is the formula that is giving the error:
=SUMIFS({Expense Collector Range 4}, {Expense Collector Range 1}, "Groceries", {Expense Collector Range 5}, >=DATE([Start Date]12), {Expense Collector Range 5}, <=DATE([End Date]12))
The [Start Date]12, and [End Date]12 references are pointing at the correct locations. Any ideas??
