A range is a collection of cells, for example A1:a10 is a range. To name your range goto insert/name/define. In the popup window on the top line place a name, example Totals, on the bottom line where it says refer to put the cell range. In this case A1:a10....That's all there is to it.
Denny