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
Adding Numbers in Excel?
I have a list of numbers in column A. Let's say those numbers are 5, 10, 15, 20 in cells A1, A2, A3, A4 respectively. In column B I need to add the square of it's cell A counterpart plus all the squares of the numbers before it ('it' being the cell A counterpart).
B1 would be "=A1^2"
B2 would be "=A1^2+A2^2"
B3 would be "=A1^2+A2^2+A3^2"
B4 would be "=A1^2+A2^2+A3^2+A4^2"
Now I have a lot more numbers in column A than just those 4 so I need a formula which I can copy over to the rest of column B. Any ideas?
So there is no way for Excel to add more terms as the cells progress?
1 Answer
- braydenLv 710 years agoFavorite Answer
B1 would be =A1^2
B2 would be =(A2^2)+B1
B3 would be =(A3^2)+B2
Etc
