Many thanks for your reply.

That makes sense, so if I use the little auto sum symbol in the top right-hand corner, it defaults to the summation of the range that I have selected by clicking and dragging? Can I use the auto sum facility to select individual cells that aren't next to each other?