 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / August 2007Can't sort column of SUM values
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??? > I'm having a strange data sorting problem where my table won't sort a > column of values that are SUMs of other columns. [quoted text clipped - 30 lines] > > John  SignatureDave 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. > 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 [quoted text clipped - 7 lines] > > Thanks... SignatureDave 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. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > 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 [quoted text clipped - 7 lines] > > Thanks... Do you have any blank rows in the data? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.