JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 582
- Office Version
- 365
- Platform
- Windows
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
<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>
[TD="class: xl65, width: 52, align: right"]05.16[/TD]
[TD="class: xl66, width: 27, align: right"]2[/TD]
[TD="class: xl66, width: 22, align: right"]1[/TD]
[TD="class: xl67, width: 40, align: right"] 02.12
[/TD]
[TD="class: xl68, width: 33, align: right"].036[/TD]
[TD="class: xl69, align: right"]03.18[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70, align: right"]0[/TD]
[TD="class: xl71, align: right"]01.18[/TD]
[TD="class: xl72, align: right"].002
[/TD]
[TD="class: xl69, align: right"]02.12[/TD]
[TD="class: xl70, align: right"]0[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl71, align: right"]00.11[/TD]
[TD="class: xl72, align: right"].014[/TD]
[TD="class: xl69, align: right"]06.19[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl71, align: right"]01.18[/TD]
[TD="class: xl72, align: right"].008
[/TD]
[TD="class: xl69, align: right"]08.83[/TD]
[TD="class: xl70, align: right"]4[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl71, align: right"]01.82[/TD]
[TD="class: xl72, align: right"].008[/TD]
[TD="class: xl69, align: right"]15.05[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]06.04[/TD]
[TD="class: xl72, align: right"].009[/TD]
[TD="class: xl69, align: right"]11.48[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl70, align: right"]5[/TD]
[TD="class: xl71, align: right"]00.47[/TD]
[TD="class: xl72, align: right"].005[/TD]
[TD="class: xl69, align: right"]12.32[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]4[/TD]
[TD="class: xl71, align: right"]01.30[/TD]
[TD="class: xl72, align: right"].019[/TD]
[TD="class: xl69, align: right"]15.36[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]01.35[/TD]
[TD="class: xl72, align: right"].010[/TD]
[TD="class: xl69, align: right"]09.78[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl71, align: right"]00.77[/TD]
[TD="class: xl72, align: right"].014[/TD]
[TD="class: xl69, align: right"]20.13[/TD]
[TD="class: xl70, align: right"]9[/TD]
[TD="class: xl70, align: right"]8[/TD]
[TD="class: xl71, align: right"]03.11[/TD]
[TD="class: xl72, align: right"].015[/TD]
[TD="class: xl69, align: right"]14.03[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]00.02[/TD]
[TD="class: xl72, align: right"].007[/TD]
[TD="class: xl69, align: right"]17.86[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]04.84[/TD]
[TD="class: xl72, align: right"].022[/TD]
[TD="class: xl69, align: right"]28.39[/TD]
[TD="class: xl70, align: right"]12[/TD]
[TD="class: xl70, align: right"]15[/TD]
[TD="class: xl71, align: right"]01.35[/TD]
[TD="class: xl72, align: right"].039[/TD]
</tbody>
<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>
[TD="class: xl65, width: 52, align: right"]05.16[/TD]
[TD="class: xl66, width: 27, align: right"]2[/TD]
[TD="class: xl66, width: 22, align: right"]1[/TD]
[TD="class: xl67, width: 40, align: right"] 02.12
[/TD]
[TD="class: xl68, width: 33, align: right"].036[/TD]
[TD="class: xl69, align: right"]03.18[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70, align: right"]0[/TD]
[TD="class: xl71, align: right"]01.18[/TD]
[TD="class: xl72, align: right"].002
[/TD]
[TD="class: xl69, align: right"]02.12[/TD]
[TD="class: xl70, align: right"]0[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl71, align: right"]00.11[/TD]
[TD="class: xl72, align: right"].014[/TD]
[TD="class: xl69, align: right"]06.19[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl71, align: right"]01.18[/TD]
[TD="class: xl72, align: right"].008
[/TD]
[TD="class: xl69, align: right"]08.83[/TD]
[TD="class: xl70, align: right"]4[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl71, align: right"]01.82[/TD]
[TD="class: xl72, align: right"].008[/TD]
[TD="class: xl69, align: right"]15.05[/TD]
[TD="class: xl70, align: right"]2[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]06.04[/TD]
[TD="class: xl72, align: right"].009[/TD]
[TD="class: xl69, align: right"]11.48[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl70, align: right"]5[/TD]
[TD="class: xl71, align: right"]00.47[/TD]
[TD="class: xl72, align: right"].005[/TD]
[TD="class: xl69, align: right"]12.32[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]4[/TD]
[TD="class: xl71, align: right"]01.30[/TD]
[TD="class: xl72, align: right"].019[/TD]
[TD="class: xl69, align: right"]15.36[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]01.35[/TD]
[TD="class: xl72, align: right"].010[/TD]
[TD="class: xl69, align: right"]09.78[/TD]
[TD="class: xl70, align: right"]3[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl71, align: right"]00.77[/TD]
[TD="class: xl72, align: right"].014[/TD]
[TD="class: xl69, align: right"]20.13[/TD]
[TD="class: xl70, align: right"]9[/TD]
[TD="class: xl70, align: right"]8[/TD]
[TD="class: xl71, align: right"]03.11[/TD]
[TD="class: xl72, align: right"].015[/TD]
[TD="class: xl69, align: right"]14.03[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]00.02[/TD]
[TD="class: xl72, align: right"].007[/TD]
[TD="class: xl69, align: right"]17.86[/TD]
[TD="class: xl70, align: right"]6[/TD]
[TD="class: xl70, align: right"]7[/TD]
[TD="class: xl71, align: right"]04.84[/TD]
[TD="class: xl72, align: right"].022[/TD]
[TD="class: xl69, align: right"]28.39[/TD]
[TD="class: xl70, align: right"]12[/TD]
[TD="class: xl70, align: right"]15[/TD]
[TD="class: xl71, align: right"]01.35[/TD]
[TD="class: xl72, align: right"].039[/TD]
</tbody>