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)

Find more posts tagged with

Forms

Education

Formulas

Reports

Product Development

Project Management

Cell linking

Comments

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

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

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

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)