and welcome to JustAnswer.com
I will do my best to help
The easiest way to sum column is to type the formula directly in the cell
A1 is the starting cell and A5000 is the last cell you want to include in SUM
Do you wish to SUM complete row maybe?
Let me know whatever you need, I can help
I'm not sure I understand...
For example... I can sum cells A1:D1 in E1..
Now I want to sum cells A2:D2 in E2 and so on... so how do I get through to E6000
Ok. In the text field that is on top of all cells just before the formula field
just enter E6000
No. I want to Sum each of the rows down the column.
then in formula text field type the formula command
Ok. If you have more rows that you want to sum
then when you for example put all A2:D2 to sum in E2
now if you select E2
Help, are you there?
and put a mouse in bottom-right corner of the cell you will get + instead of your regular cursor
then just click when + shows up and scroll down E3, E4, E5
and it will consequently sum A3:D3, A4:D4, A5:D5
I don't know if you understood well, but please try and let me know if this is what you want to achive
After I Sum a number of columns in a row, the rows that are below the first row also has data in each of the columns...
How do I Sum each row (say, for 6000 rows) without having to drag the cursor down the entire column?
Can I insert a formula someplace to SUM each row in the range?
Yes, you can
please try all I wrote above
sum one row
then select the cell where SUM formula is
then put mouse cursor to the bottom-right of that cell and + sign will show
after you see + press left click on mouse and scroll down
Hold on... and let me try.
Help, I don't want to scroll down... you try scrolling down 6000 rows, and it takes forever.
yes, but you just have to do this once. It's the easier way
you don't have to scroll through each row
it will automatically sum complete row, and you have to scroll just through one column
I have one worksheet that has 50,000(!) rows... to scroll down that many takes a really long time... That's why I came to you folks.
Ok. Hold on
I will try to find the simpler solution
FYI... I've made up a very simple spread sheet, so I can try out what you suggest.
The other way is to use the Macros and write a script that will do what you want to achive
How do I do that?
Hold on just a minuet
I have entries in Row 1: Columns A, B, C and E and have Summed them in Column E.
Now I also have data in Rows 2, 3, 4, 5 AND 6, in Columns A:D and want to sum each of the rows in Column E without having to drag
Ok. Select cell E in row 1
then put mouse (don't click) in bottom-right edge of the selected cell
then when + shows click and drag down
Help, is my E1 supposed to be empty or does it have the formula?
you have to SUM just for this E1 cell
then when you put mouse to + and drag down it will SUM from it self for all other rows
Ok. I found even more simpler solution
I know how to do that... but it'll take forever to do 50,000 rows.
Please use SUM formula for E1 cell
then select E1 cell
click CTRL+SHIFT+DOWN ARROW
then press CTRL+D
Please try this
Help... I pushed down simultaneously on CTRL+SHIFT+DOWN ARROW, the released and pushed CTRL+D... Nothing happened.
Ok. Did you select E1 cell first
after you press CTRL+SHIFT+DOWN arrow on keyboard all cells bellow E1 should be selected
Yes, I started with the cursor in E1
Note that all cells bellow E1 must be blank
I tried with the cursor in the cell E0 and it showed the formula and highlighted the entire column... I think we're getting closer.
then just if you sum to E1 cell
after you press CTRL+SHIFT+DOWN arrow it will select complete column bellow E1 cell
then when you press CTRL+D it will
put sum formula to E2, E3, E4 and all other cells bellow
Nothing happens when I press Control+Shift+Down arrow
You said above that it highlighted the whole column
Note once again that all bellow columns must be blank
No. the entire column was highlighted when I went to E0
All rows in column E below row 1 are blank..
I am working with a Mac... anything to this?
Can you try all of these in a new spreadsheet
just fill out A, B, C column
rows 1, 2 3
then in D1
sum A1, B1, C1
then select D1 and press CTRL+SHIFT+DOWN arrow and let me know if it selects all bellow cells
yes... and nothing is happening
if you press CTRL+SHIFT+RIGHT arrow
Hey, Command+Shift+Down arrow highlights the column
Command+Shift+Down arrow, then Control D works.
then press Command+D to fill all bellow with SUM formula
It's a little bit different as some keyboards doesn't have Command button, just CTRL
I am happy, since this now works!!!
Ok. Great. I am glad that we solved it
Thank you very much for using JustAnswer and have a great day
Please don't forget to rate my answer if you were satisfied
One more question... the rest of the
One more question, the rest of the rows have "0" how do I empty the rows with no data?
HOld on just a minuet
As you can guess, I now have the opposite problem, I have a "0" in the remaining 50,000 or so rows.
I'll hold on a "minute." I don't dance the 'minuet' I think I can joke with you.
I understand, there is a solution to that problem too
I could "cut/copy and paste" the good data to another worksheet, but then I'd have to highlight and scroll down... not good
I know. We have to change the formula
Okay. Let's do it.
Ok. Formula is
if you put the formula in E1
then if there is no data in A1, B1 or D1 it will show null in E1
it will not show zero
hold on please... NOPE.
I tried on my sheet
Help, I had only 3 (A,B,C) columns of data... I did the Sum macro in D1, AND I TRIED THE FORMULA IN E1 AND GOT AN ERROR MESSAGE. I TOOK THE FOMULA THAT WAS SUGGESTED BY EXCEL AND GOT A "VALUE" IN E1.
Hold on, I will change it for D1 field
put this in D1
Help, am I supposed to do the Command+Shift+Down arrow, the Control D first?
No. First put the formula in D1
then do Command+Shift...
Please use this formula above instead of regular SUM formula
just copy/paste it to D1 cell
Okay, I got it to work... after you enter the fancy formual... you then do the Command+Shift+Down arrow, then Control D.
Please let me write this down...
Okay... I think I have it...