Can't sort column of SUM values

[robotman]

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]

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]

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]

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

 

[Ragdyer]

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.

 

[scal]

Do you have any blank rows in the data?