Formula for adding columns

[Pinz]

I'm trying to enter a formula to add two columns together. I can't seem to do it. I can do it for individual cells (C1=SUM(A1+B1)....but if I enter the column letter to designate the entire column C=SUM(A=B), it won't take......can you help? Thanks in advance!

 

[Guest]

Not quite sure what you're looking for...
but you had it right in the first formula.

Type in =sum(a1+b1) , then either use the autofill feature
or copy it down the rest of the column.

-----Original Message-----
I'm trying to enter a formula to add two columns

together. I can't seem to do it. I can do it for
individual cells (C1=SUM(A1+B1)....but if I enter the
column letter to designate the entire column C=SUM(A=B),
it won't take......can you help? Thanks in advance!

 

[A.W.J. Ales]

Pinz,

In general when summing two columns use =SUM(A:A,B:B).

In this special case where the two columns can be taken together :
=SUM(A:B)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

I'm trying to enter a formula to add two columns together. I can't seem

to do it. I can do it for individual cells (C1=SUM(A1+B1)....but if I enter
the column letter to designate the entire column C=SUM(A=B), it won't
take......can you help? Thanks in advance!