help this newb out!

importpsycho

New Member
Joined
Jan 15, 2004
Messages
3
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.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
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
Joined
Sep 15, 2002
Messages
769
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
Joined
Jan 15, 2004
Messages
3
thank you very much! :biggrin:

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 :pray:
 

Watch MrExcel Video

Forum statistics

Threads
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?

Disable AdBlock

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
Top