Sum if formula

Dorota Dunne
Dorota Dunne ✭✭
edited 02/19/24 in Formulas and Functions

hi, Where am I going wrong with this formula:

=SUMIF({Data Range 2}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), CONTAINS({Data Range 42}, "risk01"), {Data Range 43})

I'm trying to calulate the year to date financial impact for Risk 01. Each incident can impact multiple risks. Data Range 2 is the date of occurance. Data Range 42 is the Risk type (can be multiple risks in one cell) and Data Range 43 is the $ amount of financial impact.

thank you

Dorota

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!