I'm trying to replace the hardcoded references E13:E15 with relative references:
I've tried variations of below, in cell e16, but nothing seems to work:
I'm getting #VALUE! errors. I assume it's because the Array reference isn't quite right but I'm not sure what it should be.
Yes, I've been using ctrl-shift-enter.