Hi Sktneer,

Thanks for this. I can see what you are doing with this formula, but it doesn't work for some reason, as it returns the { do appear }.

I'm using this:
{=SUM(IF(H2:H62="",H2:H61))}

It is not returning any errors, expect the reference to empty cells.