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
Excel Question: How do I make each cell in column add up the numbers in cells B through E?
I want to have all the cells in one column automatically total some of the cells to the immediate left. I can easily do this for each one but I want the sum applied to all the cells in the column to do the total for each row.
I need to have a generic formula I can paste into all the cells of a column.
5 Answers
- VBAXLManLv 61 decade agoFavorite Answer
If your column is F, then paste this in cell F1
=SUM( B1:E1)
then just copy and paste that cell to the cells below
PS: The guys did answer you well, nut you may did not understand them well
Enjoy my profile, VBAXLMan is back
- 1 decade ago
In the F1 cell put this formula:
=sum(b1:e1)
press enter
then copy F1 (ctrl-C).
Select column F by clicking the F at the top of the column. Now paste (ctrl-V).
The formula is now in every cell in column F
- Anonymous1 decade ago
highlight all the cells where you want the answer to appear then type = select cell in first row B through e and then compplete with Shift control return creating an array formula
Source(s): knowlwdge of array calculations - {*.*} SDLv 41 decade ago
ummm... so you want the totals of column cells B-E in cells F??
in the cells in the F column do this formula:
=sum(b1:e1)
press enter
then copy and paste the cell that you just completed and paste it into the cells below it.
or try
=sum(b1:e99)
- 1 decade ago
make the range be absolute values by adding $. =$b$24:$e$24 not using 24 but whatever the cell numbers are. good luck. then stretch it with the corner thing.
