Check and make sure that calculation is set to automatic.
ToolsOptionsCalculation
Biff
"Wozza" wrote in message
...
=SUM(G5:G11) if I change any cell in the range, the sum is not performed.
I
have to select the sum cell, F2 then Enter in order to get the sum to work
|