Sumifs with references and dates not calculating

VTwyford

HELP!!!! I am working in a summary metrics sheet. I am trying to find the total projected revenue by month. I have created 2 references, the revenue column to sum, and the date column. For some reason I keep getting 0 even though there is revenue in the column for that date. I can't figure out what is wrong with my formula.

=SUMIFS({Implementation List with Form Range 7}, {Front Office Team Range 1}, <=DATE(2023, 1, 1), {Front Office Team Range 1}, >=DATE(2023, 1, 31))

This is trying to find the projected revenue for January

Carson Penticuff

As written, you will not get any matches. Your formula is looking for a date that is both less than or equal to January First and Greater than or equal to January 31st. You will need to reverse those to match January numbers.

Carson Penticuff

As written, you will not get any matches. Your formula is looking for a date that is both less than or equal to January First and Greater than or equal to January 31st. You will need to reverse those to match January numbers.

VTwyford

Oh my goodness! Thank you so much for catching that!!

Carson Penticuff

Far too often, its the little things...