Please help, I know nothing

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

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 many
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 pointerwill
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 need
the following formula in c1

=SUM(A:B)


---
Message posted from http://www.ExcelForum.com/

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

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
.

amme wrote:

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

Are you looking for a running total (or checkbook Balance
column) if so see
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"gls858" wrote in message ...
amme wrote:

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