Thanks Biff...not sure how it got set to manual!

"Biff" wrote:

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