Hi,
I have a cell with address information (address function). Now i want to sum a number of cells up to that address.
Any idead how I would do this.
ie sum(a10:ADDRESS(10,(E7),4))
Regards
Ger
Printable View
Hi,
I have a cell with address information (address function). Now i want to sum a number of cells up to that address.
Any idead how I would do this.
ie sum(a10:ADDRESS(10,(E7),4))
Regards
Ger
Use INDIRECT(E7) instead ADDRESS.
I suppose you have something like "J10" stored in E7.
Then the sum looks like SUM(A1:INDIRECT(E7))
Works?