Hi,

I had figured it needed to be an array as well but it still produces
the same result.

I unfortunately cannot use a simple sum equation either. I have
stepwise calculations on raw
data and I have to ensure that true zero's are kept in while empty
cells (with no raw data) are continuously considered blank (not
zero's). For the example above I cannot use a simple sum function
(which would work if I was only missing 1 or 2 cells of the range)
because if all three cells are missing/blank in the previous
calculation, they have to return a blank, not a zero.

Thanks,
Elaine