Hi!
When we define a cell or an array in excel, the defined cell reference is
then an absolute reference.
In your example, after you define the reference as "ADD", in any cell of
the workbook if you write =sum(ADD), you will get result as 40.
Hope this resolved your query.
Regards
Ritesh Agarwal
Hello,
Thank you for this wonderful presentation.
I used a formula after defining a cell range and it worked well.
However, when I tried to copy that formula to the cell below, it did
not work as expected. Normally, the formula is automatically corrected
when copied to the cell below. In the case
Namaste!
While using formulas, do you fail to remember the cell range, table or
functions?
Define name is a feature of MS Excel which can sort out your problem.
By using names, you can make your formulas much easier to understand.
You can define a
name for a cell range, function, constant, or tabl