|You should look up the differences between Absoloute and Relative references in the Excel Help files and/or Google.|
Place this in C1 and drag it down:
The ranges with the $ are Absolute References and will not change if you drag the formula down or across.
The range without the $ (B1) is a relative address and will change as you drag the formula around.
You can highlight the range in a formula and press F4 to cycle through the 4 referencing choices.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.