Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sort creating total errors
I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical
data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! |
#2
|
|||
|
|||
What are the formulas you used in those total cells?
excel idiot wrote: I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! -- Dave Peterson |
#3
|
|||
|
|||
I just did a sum formula =sum(a1:a5)
"Dave Peterson" wrote: What are the formulas you used in those total cells? excel idiot wrote: I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! -- Dave Peterson |
#4
|
|||
|
|||
Well, if you're adding up what's in A1:A5 and sorting what's in rows 1:8000,
that could be the problem. If you meant that you used a formula _like_ =sum(a1:a5) but more like: =sum(a1:a8000) then I don't have a guess. excel idiot wrote: I just did a sum formula =sum(a1:a5) "Dave Peterson" wrote: What are the formulas you used in those total cells? excel idiot wrote: I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Is the row at the bottom still "Totals" or is it now the numbers for a
person, like for example "Winston?" -IanRoy "excel idiot" wrote: I just did a sum formula =sum(a1:a5) "Dave Peterson" wrote: What are the formulas you used in those total cells? excel idiot wrote: I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! -- Dave Peterson |
#6
|
|||
|
|||
It is still just for totals.
"IanRoy" wrote: Is the row at the bottom still "Totals" or is it now the numbers for a person, like for example "Winston?" -IanRoy "excel idiot" wrote: I just did a sum formula =sum(a1:a5) "Dave Peterson" wrote: What are the formulas you used in those total cells? excel idiot wrote: I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! -- Dave Peterson |
#7
|
|||
|
|||
Hi E.I.
Try this: select any name and sort up or down In you approach, the achor point for the SUM-range are moved with the name. A basic rule: never select before a sort. If you have to, there is something wrong with your list. Frans "excel idiot" wrote in message ... I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! |
#8
|
|||
|
|||
Make sure you are not selecting the total row. Make new
worksheet so you do not destroy you existing data. Put Numbers in A1-A5, put a total in A6. Select A1-A5 and sort. Did A6 change? -----Original Message----- I have a spreadsheet with about 20 columns and 8,000 rows. I have numerical data in most of the columns corresponding to people. Like this: John 9 6 Debbie 9 5 James 8 5 Total 26 16 If I highlight all columns and do a sort by the person's name, the total number at the bottom changes even if the data has not changed. Do you know why this is happening? Thanks in advance for any help! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I sort email address, dedupes,check for errors in a docume. | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |