add contents of one column

P

Pam

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.
 
B

Bob Phillips

In B1: =SUM(A:A)

--

HTH

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

DaveB

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top