With a formula you can type for example =SUM(RANGE) and it will sum the information in range name called RANGE.
If I had a cell in just say A1 that stated a named variable (range name) IE it said the text field RANGE, how can I get the =SUM(text(a1,"@") to return the same value as it I had typed in the name.
If I had a cell in just say A1 that stated a named variable (range name) IE it said the text field RANGE, how can I get the =SUM(text(a1,"@") to return the same value as it I had typed in the name.