Sum if formula

Question

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

Dorota Dunne · Answer

thank you Razetto

Razetto · Answer

@Dorota Dunne Hi, Try it out first by adding the @cell ="risk01", if that doesn't work then I would remove the iferror. Do you have the iferror because the column is not always a date or blank? I would restrict it so it's a date. You can always use a not(isblank statement instead and see if that works out.