Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting changes totals!?!?
Windows 2000 Pro/ Office 2000 Pro
I have a Worksheet that has 1671 rows of data and formulas at the bottom of several columns. Column "M" contains data values imported from another App and Columns G & H contain the formulas =if($M1=0, $M1,0) and =if($M1<, $M1,0) respectively. I have verified all cells within the relevant range have been formatted as "Number" and even multiplied the values in column "M" by 1, as suggested in the KB to ensure they were converted to numbers and did not come over as text. While working in the file yesterday, I sorted the data and the "Sums" for all =Sum ()formulas changed! I recopied the formulas in columns G & H and then resorted with the same result (actually, different results = the totals changed again!) The totals are not consistent with the sort. For example If I sort by column A I get one total, I sort by Column B I get a different total, If I go back and sort by column A again, I get a completely different total. I have never run into this before and I have no idea what else to check.. Any suggestions? I checked several other worksheets and workbooks and they do not appear to have this problem TIA BAC |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting changes totals!?!?
BAC Wrote: Windows 2000 Pro/ Office 2000 Pro I have a Worksheet that has 1671 rows of data and formulas at the bottom of several columns. Column "M" contains data values imported from another App and Columns G & H contain the formulas =if($M1=0, $M1,0) and =if($M1<, $M1,0) respectively. I have verified all cells within the relevant range have been formatted as "Number" and even multiplied the values in column "M" by 1, as suggested in the KB to ensure they were converted to numbers and did not come over as text. While working in the file yesterday, I sorted the data and the "Sums" for all =Sum ()formulas changed! I recopied the formulas in columns G & H and then resorted with the same result (actually, different results = the totals changed again!) The totals are not consistent with the sort. For example If I sort by column A I get one total, I sort by Column B I get a different total, If I go back and sort by column A again, I get a completely different total. I have never run into this before and I have no idea what else to check.. Any suggestions? I checked several other worksheets and workbooks and they do not appear to have this problem TIA BAC I am not sure if it will work, but try full address references in the formulas, I mean including the sheet name Ilan -- ilanr01 ------------------------------------------------------------------------ ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797 View this thread: http://www.excelforum.com/showthread...hreadid=401496 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by Sub-Totals | Excel Discussion (Misc queries) | |||
sorting and adding totals | Excel Worksheet Functions | |||
sorting by week w/sub totals | Excel Worksheet Functions | |||
Sorting by date, then calculating totals | Excel Programming | |||
Totals and Sorting | Excel Programming |