I have tried changing it to an array but then will get a blank cell
whenever any of the 3 cells are blank.

I must be using the wrong formula - what I want to do is have a formula
that will sum any cells within the range that have a number but if ALL
of the cells are empty I need the formula cell to remain blank.