Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now 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
Help again for a formula in Excel?
I have data from A2 to A100. On B2, it contains the data from the number of rows that must be added in column.
For example if B2 contains 5, it means I need the sum from A2 to A6 (5 rows). I want to make a formula like this :
=SUM(A2:A(B2+1))
I know this is not a valid formula and it doesn't make sense but this is the basic idea. How can I make a formula whose cell number depends on the data on another cell? (Sorry for the noob question)
2 Answers
- Anonymous4 years ago
Assuming A1 is the 1st Away/homestead field and E1 is the 1st win/lose field, you should apply this formulation: =IF(A1="Away",IF(E1="W",3,0),IF(A1="Ho... -yk P.S. solutions in basic terms truncated my formulation, so i'm going to objective it back with areas around each parenthesis. in basic terms get rid of the areas. =IF ( A1="Away",IF ( E1="W",3,0 ) ,IF ( A1="homestead",IF ( E1="W",2,0 ) ,0 ) )