Help with a SUMIFS formula?

PKane

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

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.