Numbers: calculating sum of variable range

[Janx]

Hi

I want to sum the values in one table between column C2 and a variable end. I thought the ADDRESS function might help and tried the following:
(if this would have worked, I'd replace the 7 with 7+A1):

=SUM(Table 2 :: C2:ADDRESS(7,3))

The result is the value of column C2

=ADDRESS(7,3) returns C7

Does SUM not take ADDRESS as an argument?

Thanks,
jan