Sheet Summary with 2 conditions including date range


I'm attempting to write a summary sheet formula that sums a number based on two conditions: 1 for entries <1/1/2021 and another column with a drop down choice of categories for only one category. Any luck writing a formula for a sum of two conditions? Should I be using SUMIF? How do I format both the conditions in the formula?

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi @Drea Mora ,

    You'll want to use a SUMIFS formula:

    =SUMIFS([column to sum]:[column to sum],[date column]:[date column],<DATE(2021,1,1),[drop down column]:[drop down column],"dropdown value")

    Note - this will work for a single dropdown column. If you have a multi-select dropdown, let me know and we can adjust it.

    Let me know if it works for you.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!