I want to use the cell reference generated by ADDRESS as the number value
(start of the range) in the SUM function.

For example the result of my ADDRESS function is $C$5 and I want the range
in SUM to start at $C$5 to an end reference. However, when I point to the
cell which contains my ADDRESS function and shows $C$5 as the result, the SUM
function just takes the cell reference of where the ADDRESS fucntion is and
not the outcome.