i do a simple sum(a1-a5). it will not return a value until i do an autosum
formula.

also- when i add a number to the the blank cell in the array, the sum
formula will not automatically calculate the sum until i do the autosum
function!