Names in EXCEL
If you need to add the values in a column, for proper operation of Your formulas, You will probably need dynamic ranges that automatically increase or decrease depending on the amount of your data.
Usually formulas directly entered into cells, but you can pre-assigning the formula to use in cell its name. What are the benefits of a named formula read in this article.
Usually reference the cell ranges are entered directly in formulas, e.g. =SUM(A1:a10). Another approach is to use as a reference a range name. The article will consider what are the advantages of using a name.
Name you can assign a cell range, formula, constant, or table. The use of the name allows to simplify the formulation, to reduce the number of typos and incorrect links to use tricks that are difficult to do otherwise.