I'm having a strange data sorting problem where my table won't sort a
column of values that are SUMs of other columns.

For example, the formula in Row 2 in the sorting column H is:
= SUM (A2, C2, F2, G2)

When I do the sort of Col H, most of the numbers are in the right
order, some of the sums are out of order. Not sure if it's just a
coincidence, but it seems only the 11 sums that seem to get mis-
sorted.

55
52
25
23
11
15
12
11
0
0
0
0
11
11
0
0
0

Anyone have any idea why this is happening?!

Thanks.

John

If you're just sorting that column, maybe you can convert it to values first.
Or copy the values to column I and sort both columns by column I.

Or you could select the whole range (A2:Hxx???) and sort by column G???

robotman wrote:
>
> I'm having a strange data sorting problem where my table won't sort a
> column of values that are SUMs of other columns.
>
> For example, the formula in Row 2 in the sorting column H is:
> = SUM (A2, C2, F2, G2)
>
> When I do the sort of Col H, most of the numbers are in the right
> order, some of the sums are out of order. Not sure if it's just a
> coincidence, but it seems only the 11 sums that seem to get mis-
> sorted.
>
> 55
> 52
> 25
> 23
> 11
> 15
> 12
> 11
> 0
> 0
> 0
> 0
> 11
> 11
> 0
> 0
> 0
>
> Anyone have any idea why this is happening?!
>
> Thanks.
>
> John

--

Dave Peterson

Since the table will be updated frequently, I don't want to do a copy
and paste special -> values every time I want to sort the table
(although that does work).

I've also tried summing the entire range, i.e. H2 is =SUM(A2:G2), and
then sorting Col H, but that doesn't solve the problem.

Any other ideas why the table won't sort correctly when sorting by
this column of SUMs?

Thanks...

When I selected A2:G(whatever), then sorted by column G, it worked ok for me.



robotman wrote:
>
> Since the table will be updated frequently, I don't want to do a copy
> and paste special -> values every time I want to sort the table
> (although that does work).
>
> I've also tried summing the entire range, i.e. H2 is =SUM(A2:G2), and
> then sorting Col H, but that doesn't solve the problem.
>
> Any other ideas why the table won't sort correctly when sorting by
> this column of SUMs?
>
> Thanks...

--

Dave Peterson

How can you sort a column of *relative* formulas?

The cell references will change with the new location of the formulas!

You'll need *absolute* referencing (=SUM($A$2,$C$2,$F$2,$G$2),
OR
Sort the *entire* datalist.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"robotman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Since the table will be updated frequently, I don't want to do a copy
> and paste special -> values every time I want to sort the table
> (although that does work).
>
> I've also tried summing the entire range, i.e. H2 is =SUM(A2:G2), and
> then sorting Col H, but that doesn't solve the problem.
>
> Any other ideas why the table won't sort correctly when sorting by
> this column of SUMs?
>
> Thanks...
>

Do you have any blank rows in the data?