Sumif/Sumifs question

I have a sheet that lists the number of awards that have been issued since the inception of the program. I want to create a report that breaks it out by year, award level (there are 3 different levels), and sum the total of that level. I have it by year, but adding the level I have not been able to figure out. Can someone point me down the correct path?



  • Jason Tarpinian
    Jason Tarpinian ✭✭✭✭✭✭

    You'll look to something like this:

    =SUMIFS([Dollar Value]:[Dollar Value], Year:Year, "2021", Level:Level, "Low")

    "2021" or/and "Low" could be a reference as well if you don't want a static criteria to be your match criteria.

    Jason Tarpinian - Sevan Technology

    Smartsheet Aligned Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!