SUMIFS Formula Assistance

jvanhemm ✭✭✭
edited 05/17/23 in Formulas and Functions

I have a sheet in which I want to SUM a column of data if the status is equal to a value and the year is equal to 2023. It seems to not like my year criteria

=SUMIFS([SaaS Value]:[SaaS Value], Status:Status, "Active", Year:Year, "2023")

Specifically I am getting an invalid data type error



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!