Sumifs with references and dates not calculating

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

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!