I tried posting this once but it didn't seem to work, my apologies if it appears twice.
I would like to dynamically construct a range to be used in a SUM function but I can not get the addresses into the function after constructing them.
For example, I create the addresses of lower and upper limits of the range using the ADDRESS function, and then I want to put them in the SUM function. I thought the following would work to add up only the data under the months up to this month (I have the data for 12 months in row 5 starting at column H):
SUM(ADDRESS(ROW(F5),8,4):ADDRESS(ROW(F5),(7+MONTH(TODAY())),4))
but the output from the ADDRESS function is text and not accepted as an actual address.
Can anyone help?
Thank you,
Brian
I would like to dynamically construct a range to be used in a SUM function but I can not get the addresses into the function after constructing them.
For example, I create the addresses of lower and upper limits of the range using the ADDRESS function, and then I want to put them in the SUM function. I thought the following would work to add up only the data under the months up to this month (I have the data for 12 months in row 5 starting at column H):
SUM(ADDRESS(ROW(F5),8,4):ADDRESS(ROW(F5),(7+MONTH(TODAY())),4))
but the output from the ADDRESS function is text and not accepted as an actual address.
Can anyone help?
Thank you,
Brian