add contents of one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
Back
Top