add contents of one column
 

I have a budget that I want to automatically add the contents of one column
as I'm working on the sheet. I am new to this and I need all of the helo that
I can get.

In B1: =SUM(A:A)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pam" wrote in message
...
I have a budget that I want to automatically add the contents of one
column
as I'm working on the sheet. I am new to this and I need all of the helo
that
I can get.

Assume your numbers that you want to add are in the range A1 to A1000. Enter
this function in a cell that you want the sum of these values to appear
(note: anywhere BUT a cell in the range you want to sum... in this case A1
to A1000):

=SUM(A1:A1000)

Does that help?
--
Regards,

Dave


"Pam" wrote:

I have a budget that I want to automatically add the contents of one column
as I'm working on the sheet. I am new to this and I need all of the helo that
I can get.