Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does not add up properly
Hi
I have a spreadsheet with app 800 names sorted in alphabetical order. To the right of the names I have a few col on numbers. At the bottom of each col I have a calculated total for that col(i.e. @SUM (c2...c800) From time to time I have to add new names. I usually type in the names below the 800 line and then do a sort on the names. At this stage the name is inserted in the proper place BUT MY COL TOTAL are no longer accurate. The formula at the bottom now read(as an example) @sum(c12...c800) How can I stop this from happening. Thanks -- Norton Professional 2004 says this email is clean...believe it |
#2
|
|||
|
|||
http://www.mcgimpsey.com/excel/pennyoff.html
-- Kind Regards, Niek Otten Microsoft MVP - Excel "PCOR" wrote in message ... Hi I have a spreadsheet with app 800 names sorted in alphabetical order. To the right of the names I have a few col on numbers. At the bottom of each col I have a calculated total for that col(i.e. @SUM (c2...c800) From time to time I have to add new names. I usually type in the names below the 800 line and then do a sort on the names. At this stage the name is inserted in the proper place BUT MY COL TOTAL are no longer accurate. The formula at the bottom now read(as an example) @sum(c12...c800) How can I stop this from happening. Thanks -- Norton Professional 2004 says this email is clean...believe it |
#3
|
|||
|
|||
In C801, insert
=SUM($C$2:OFFSET(C801,-1,)) just insert new lines before line 801 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... Hi I have a spreadsheet with app 800 names sorted in alphabetical order. To the right of the names I have a few col on numbers. At the bottom of each col I have a calculated total for that col(i.e. @SUM (c2...c800) From time to time I have to add new names. I usually type in the names below the 800 line and then do a sort on the names. At this stage the name is inserted in the proper place BUT MY COL TOTAL are no longer accurate. The formula at the bottom now read(as an example) @sum(c12...c800) How can I stop this from happening. Thanks -- Norton Professional 2004 says this email is clean...believe it |
#4
|
|||
|
|||
Worked great...thanks
"Bob Phillips" wrote in message ... In C801, insert =SUM($C$2:OFFSET(C801,-1,)) just insert new lines before line 801 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... Hi I have a spreadsheet with app 800 names sorted in alphabetical order. To the right of the names I have a few col on numbers. At the bottom of each col I have a calculated total for that col(i.e. @SUM (c2...c800) From time to time I have to add new names. I usually type in the names below the 800 line and then do a sort on the names. At this stage the name is inserted in the proper place BUT MY COL TOTAL are no longer accurate. The formula at the bottom now read(as an example) @sum(c12...c800) How can I stop this from happening. Thanks -- Norton Professional 2004 says this email is clean...believe it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ACAD does not display Technic font properly in office 2003-why? | Excel Discussion (Misc queries) | |||
Symbols not displayed properly in Excel chart | Excel Discussion (Misc queries) | |||
Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
Excel 2000 running on Windows XP SP2 does not properly open CSV fi | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |