the SUM function doesn't calculate if there are any blank cells in the array.

example: if i put in- sum(a1:a5) in cell a6, the return = "0". if i put in
value 1 in a1, the return is still "0"!

what's going on?