Hi,

Remove absolute references ...

=SUM(C2:C26)
HTH
Carim