Help with a SUMIFS formula?

PKane ✭✭✭✭
edited 02/23/23 in Formulas and Functions

Hello Community Peeps!

Hoping someone can help me figure out how to create a SUMIFS formula that will only Sum the projected cost columns for AC/DC/HVAC/GB if the year is 2023, 2024, 2025, etc?


  • Lucas Rayala
    Lucas Rayala ✭✭✭✭✭✭

    It's kind of hard to tell what's going on in this table -- where is the sum going? Is it a column or a row? And what do you mean by "etc"? If you are trying to create a column formula that looks across each row, you could do something like (not pretty):

    =IF(ACYear@row>=2023, ACCost@row,"")

    + IF(DCYear@row>=2023, DCCost@row,"")

    Etc, all the way down your columns.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!