EXCEL: fixed cell reference

[scroots]

if i have in excel =sum(A1:A9) and copy it down a list each cell it goes down it adds one to each value how do i stop this? do i use the dollar signs to make A1:A29 a fixed reference, i have done this before but i`m lost.

thanks in advance

scroots

[Roelf]

sum($a$1:$a$29)

[scroots]

thanks i knew it was something like that, just couldn`t get it right

thanks

scroots