trying to use output of ADDRESS function as a reference

This is one of those “there must be a way to do this” things.

Perhaps I misunderstand the point of the ADDRESS function, but it seems as though its output should be useable as a cell reference, one way or another. Instead it returns a string that cannot be plonked into another formula and treated as a reference, or not the way I’m doing it anyway. Rats!

So, for instance, let’s say I want to
sum(A10:A15)

For my own mysterious reasons, I would rather say
*sum( address(10,4) : a15 )*

Doesn’t work. Produces the error ‘address(10,4):a15 isn’t a valid reference”.

Anyone know how to fix this? How to make SUM use the output of ADDRESS?

That’s the basic question, but for context, the reason I want to reference a cell with address is because I want to include MATCH in the ADDRESS function, because I don’t actually know what row I want. So I want to get the address like so:
address(match(b12-1,b)+1,4)

Which works marvelously insofar as it returns the address of the cell where I want to start summing. But it returns it as a string, apparently.