Defining a range using a variable as the row #

Paul Bartley

Hi,

Newbie question here.

Let's say we have a simple SUM formula:

=SUM([Column1]15:[Column4]15)

Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell?

For example, rather than "15", something like

=SUM([Column1]Row:[Column4]Row)

where "Row" could be sourced from the number value in a cell?

Thanks in advance for the help.

(this would be to SUM different rows as they are added through a form, and have the SUM of the most recently added row always appear in one particular cell)

Shaine Greenwood

Hi Paul,

There currently isn't a way to create a cell reference from concatenated values like this. When you have a moment, please submit an enhancement request using the Product Enhancement Form under Quick links on the right of the community site and let our Product team know you'd like to see this feature added.

Paul Bartley

Ok, thanks for clarifying.

J. Craig Williams

Paul,

If the number you are wanting to reference (like a Row Number, but one that you have created), then

- take a look at LOOKUP() ... sorry VLOOKUP() 

or

- use SUMIFS() with that number as part of your criteria.

Both have worked for me, depending on the exact use-case.

Craig