Naming ranges in Excel
Glen Finau, Acklesh Prasad · QUT ePrints (Queensland University of Technology) · 2015
When working with functions in Excel you can reference a range of cells by simply selecting the cells. For instance if you wanted to sum all your first month sales located in the range B3:B16, the function would be =SUM(B3:B16).