Hi Sam,
type $ before the row numbers in a formula when you want them to be
constant as you fill down. A keyboard shorcut is two presses of the F4
key when you are first entering the formula. F4 once gives $C$1:$C$10,
twice gives C$1:C$10, thrice gives $C1:$C10.
Ken Johnson