Sorting with ABS

[JTL9161]

I am adding 4 columns, 3 of which have ABS totals. When I do =Sum( of the 4 columns I get correct sum but when I try to sort the 15 numbers from lowest to highest it does not put them in the correct order. The first column below is the total and this is after I sorted them. The first row of numbers I am adding are 2+1+2.12+.036 = 5.156

05.16	2	1	02.12	.036
03.18	2	0	01.18	.002
02.12	0	2	00.11	.014
06.19	3	2	01.18	.008
08.83	4	3	01.82	.008
15.05	2	7	06.04	.009
11.48	6	5	00.47	.005
12.32	7	4	01.30	.019
15.36	7	7	01.35	.010
09.78	3	6	00.77	.014
20.13	9	8	03.11	.015
14.03	7	7	00.02	.007
17.86	6	7	04.84	.022
28.39	12	15	01.35	.039

<colgroup><col style="mso-width-source:userset;mso-width-alt:1901;width:39pt" width="52"> <col style="mso-width-source:userset;mso-width-alt:987;width:20pt" width="27"> <col style="mso-width-source:userset;mso-width-alt:804;width:17pt" width="22"> <col style="mso-width-source:userset;mso-width-alt:1462;width:30pt" width="40"> <col style="mso-width-source:userset;mso-width-alt:1206;width:25pt" width="33"> </colgroup><tbody>
</tbody>

 

[kweaver]

Would you repost your example showing the negative values or indicate which column has the ABS function?
Are you wanting to sort by the first column (the sum across) or the column with the ABS function in it?

Also, you said 15 numbers, but in your post there are only 14 rows.

 

[JTL9161]

I must have missed that last row. Regardless I should have just posted 1 line. Here is the 1st line from above without the ABS. The first column is the sum of the following 4 columns. Column 2,3 and 4 have ABS. Column 3 (02.12) is not ABS.

01.08

-2

1

02.12

-.036

<colgroup><col width="52"><col width="27"><col width="22"><col width="40"><col width="37"></colgroup><tbody>
</tbody>

 

[kweaver]

Are you sorting the table based on column 1?

 

[JTL9161]

Yes. I include all columns.

 

[kweaver]

If you are sorting based on the sum column, then the rows would be arranged based on the sum. So, absolute values in other columns have no bearing on this.

 

[JTL9161]

I may not have mentioned this but the sum column is also ABS. Formula is: =SUM(ABS(AG6+AH6+AI6+AJ6))