Can't sort column of SUM values

  • Thread starter Thread starter robotman
  • Start date Start date
R

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
 
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???
 
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...
 
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.
 
Back
Top