Microsoft excel question

[tiredtoo]

I should know this but it has been awhile since i used excel and my old brain has problems remembering stuff.
formula for sum using a constant cell used to be something like. Sum(*a*1..a20)
this locks in cell a1 if i remember correctly but it will not accept the *
help me i am trying to get an accumulative total here.

[drray23]

1. Its the $ symbol you should use instead of * . Nt.

[HassleCat]

2. Did you remember the equals sign in front?

[CurtEastPoint]

3. Yep. $. Click on the cell reference in the formula bar and press F4. Or just type it in, like...

$a$4

[tiredtoo]

4. I thought i already thanked you folks, darn it is hell to get old. Thank you :)