creating and using cell references

[joeZy]

I create 2 cell references using ADDRESS() in a column.
How do I use these created cell references to sum the
numbers?
Appreciate your help. joeZy

 

[Kent]

Here's an example:

=SUM(INDIRECT(ADDRESS(1,1)),INDIRECT(ADDRESS(1,2)))

Excel Support Technician
www.canhelpyou.com