# help this newb out!

#### importpsycho

##### New Member
I need to put in column C
=sum(a1,b1) in C1
=sum(a2,b2) in C2

and to C infinity
cuz I dont know how long column A and B will be
what do I do so i dont have to type in the function in every C cells?
thanks

also I need one cell to add everything in column A
but the size of column A is not set, it will grow as I enter more number
so whatever I enter in A, should be keep adding
how do I do that?
thank you

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

##### Well-known Member
Hello and welcome to the board.

In C1 enter this formula

=SUM(A1:B1)

Put the cursor on the bottom right hand corner and double click, it should fill down to the last cell. Alternatively copy the cell down a known length which will always be greater than your data e.g. 1000 rows, or even to the last row, if needs be.

=SUM(A:A)

will add everything in col A.

#### Sourdust

##### Well-known Member
Select C1 with the formula A1 + B1, hold the Ctrl button down, then drag down column C as far as you think is needed from the bottom right hand corner of C1.

Just do a sum formula of the whole of column A (1 to 65536 if you think you need that many) in the cell you want to display the total of Column A

#### importpsycho

##### New Member
thank you very much!

one more question though
now the whole column C has 0 filled where A and B is empty
is there way to not show 0s ?

thank you thank you ray:

#### fairwinds

##### MrExcel MVP
Then try this one instead:

=IF(A1+B1,A1+B1,"")

#### importpsycho

##### New Member
thank you so much everyone!

Replies
2
Views
288
Replies
2
Views
51
Replies
9
Views
181
Replies
1
Views
80
Replies
4
Views
135

1,130,046
Messages
5,639,758
Members
417,109
Latest member
996

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back