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
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