How to find difference between 2 rows, but only if data exists in both rows?



I'm trying to make a formula that says 2020 Experiential Audit minus 2019 Experiential Audit = value in Experiential Audit YOY change...but only if there is data in both 2019 and 2020. See my sheet below.

I think this is an IF formula but I dont know how to say If there is a number...

Thank you in advance!

Best Answer


  • Amazing! As always, thank you for your help, Genevieve!

  • Any time!!

Sign In or Register to comment.