# 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

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

##### 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

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

#### importpsycho

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

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,067
Messages
5,857,134
Members
431,857
Latest member
garyjames8

### 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.

### Which adblocker are you using?

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

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