LinkBack URL
About LinkBacks
Hello,
How to define data range index from number in another cell? Whatever number I will write in that cell - SUM range will adjust to it.
1.PNG
Hello,
How to define data range index from number in another cell? Whatever number I will write in that cell - SUM range will adjust to it.
1.PNG
Last edited by rcurious; 06-21-2020 at 09:56 AM.
How about
=SUM(A3:INDEX(A:A,E2))
Thanks. That's what I was looking for.
You're welcome & thanks for the feedback.
Please explain why you want to know this cell?
For the sum formula you can use, in your example, =sum($A$3:$A$100).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
SUM is's just for example. I just wanted to know syntax in working example, how to define range index getting it from another place or formula. I seek for small steps to solve problem in Google Sheets:
https://www.excelforum.com/for-other...ible-data.html
Last edited by rcurious; 06-21-2020 at 10:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks