Please help, I know nothing

[amme]

I am a very new at this and it is driving me crazy.

For example, I want to add all of column A + column B and I want the answer to go in C. I want this action to always happen automatically. How do I do this...in easy, non-math language??

I understand the basic concept of the formula, but it will only do it in C1, e.g

I also get the error #name? Where do I enter this "name" and what is it referring to

I would appreciate any and all help

Thanks
Amme

 

[mudraker]

your question is a little vague

do you want c1 to add a1 & b1 then c2 to add a2 & b2

If yes then in c1 type in
=a1+b1

or

=sum(a1:b1)

you would then need to copy this formula down column c for hom man
rows you like

As you copy down the row numbers will change automatically

To drag fromlas down
Place mouse cusor at bottom right corner of c1 - mouse pointerwil
change to a +
click and hold left mouse botton then drag downwards



If you want c1 to add all of column a and all of column a then you nee
the following formula in c1

=SUM(A:B

 

[Michael]

Hi Amme
If you want to add ALL of columns A and B together, put
this in column C
=SUM(A:A,B:B)

However, you could add Cell A and Cell B of each row with :
=A1+B1 in cell C1. When you have done this for row 1,
highlight C1 and drag down as far as you need to go.
Then at the bottom of column C, put:
=SUM(C1:Cnnn), nnn being whatever the last cell No is.

Regards
Michael

-----Original Message-----
I am a very new at this and it is driving me crazy.

For example, I want to add all of column A + column B and

I want the answer to go in C. I want this action to always
happen automatically. How do I do this...in easy, non-math
language???

 

[gls858]

I am a very new at this and it is driving me crazy.

For example, I want to add all of column A + column B and I want the answer to go in C. I want this action to always happen automatically. How do I do this...in easy, non-math language???

I understand the basic concept of the formula, but it will only do it in C1, e.g.

I also get the error #name? Where do I enter this "name" and what is it referring to?

I would appreciate any and all help.

Thanks,
Amme

Put your formula (A1+B1) in C1. Click to highlight.
Move the cursor to the black square in the lower right
hand corner. When the cursor turn to a + click and drag
it down as many rows as you need. Now when you enter
numbers in col a and b they will total in col c.

gls858

 

[David McRitchie]

Are you looking for a running total (or checkbook Balance
column) if so see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm