Choose the ribbon command Edit names 
to assign names to cell ranges.
If, for example, your worksheet has four columns with the sales figures for spring, summer, autumn and winter, then just name these columns accordingly. You can now perform the following calculation:
=SUM(Spring)
The ribbon tab Formula | group Named areas contains all commands that you need for defined cell ranges.
For more information on working with cell ranges, see the following pages. The following topics are covered:
▪Assigning and editing names for cell ranges
▪Defining names automatically from the selection