Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Adding percentages in a column and automatic formating of contents | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |