Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
I need a little bit of help in XL?
What I am trying to do is have the sheet look at a cell say A1 (=10). And use the value (10) to tell it how many squares to add in for instance b1 to b(1+a1) so in that case it would be b1:b11. How do you do this in XL?
Rats still not there. My actual data starts on e2
So I was "e2:e"&(a1+1)? but it doesn't like that!
Nevermind that did work! Thank you very much!
1 Answer
- expletive_xomLv 71 decade agoFavorite Answer
use the indirect() function (see source)
say you want =SUM(B1:B10) or =SUM(B1:B(A1's value))
put numbers in B1 to B10
A1 = 10
A2 copy&paste this formula
=SUM(INDIRECT("B1:B"&A1))
then change A1 and the range will change
edit-
you are welcome
always good when it works
Source(s): http://www.cpearson.com/excel/indirect.htm
