Press F9 to force Excel to recalculate.
--
Brevity is the soul of wit.


"aaron" wrote:

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?