I'm working with a large Excel file on a monthly basis. In this file I have to find something like a
sum as in
The problem is that the column of the last cell in the range changes. I would like to be able to do something like this:
In a say cell
S1 I enter a value
AC and then later I can write
and have this have the same effect as though I had written
I know this can be done. I've seen it a very long time ago. It would be a huge time saver. I have hundreds of lines of the for
=sum(S2:AC2). But next month they may all have to change to
=sum(S2:BF2). To have one place to change the end of the range would be nice.
Incidentally, the row number actually changes too, but in an entirely predictable manner.
Ideally I would like to be able to concatenate the name such as:
=sum(S2: & S1 & row() )
where I'm using
row() to get the current row number