Sumif assistance needed

Black_Raven_2020

Hello,

I think it's a sum if formula I need....

If the source column says "external review" and another column called Significance says "Major" I want to return a date of +60 days to the date within column Closed date.

Eric Law

@Black_Raven_2020 You just need an IF formula. are these separate sheets or 1 sheet? Here is a quick stab at it with the info you have and the assumption of 1 sheet.

=IF(AND([Source Column]@row = "external review", Significance@row = "Major"), [Closed Date]@row + 60, "")

Black_Raven_2020

Thanks for your help Eric! Unfortunately nothing appears...not even a error code. I'm still working away at it!

James Keuning

Post a screen shot or check your spelling.