Defining a range using a variable as the row #
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)
Comments
-
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.
-
Ok, thanks for clarifying.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!