Tbone,
under the line move tab on the bottom of the sheet, this is what i got.
am looking at line numbers 18, 19, 20, 21 and 22.
line 18 shows the total with its record next to it.
line 19 shows -1.5
line 20 shows -0.5
line 21 shows 0
line 22 shows 0.5
unless my sheet is differnt then what you have, thats what i see.
line
thanks for help
cd
Example: The cut & paste from the SS is below. The group of 8 is highlighted in blue.
Followed by the opening number 8.5 which is a totally different group.
Below, the first number you see is "8", which has a "-" sign on the left of it on the SS.
If you click on that negative sign "-", it would collapse the group 8 and only shows you
the summary line which has the word "Total" in it.
The line that starts with "8 Total" is the summary line for the 8 group.
You can see that the numbers in the 3 columns do add up to the summary line.
<table style="border-collapse: collapse; width: 294pt;" border="0" cellpadding="0" cellspacing="0" width="390"><col style="width: 48pt;" width="64"> <col style="width: 60pt;" width="80"> <col style="width: 65pt;" span="2" width="86"> <col style="width: 56pt;" width="74"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt; width: 48pt;" align="right" height="17" width="64">
8</td> <td class="xl65" style="width: 60pt;" align="right" width="80">
-0.5</td> <td class="xl65" style="width: 65pt;" align="right" width="86">
4</td> <td class="xl70" style="width: 65pt;" align="right" width="86">
4</td> <td class="xl67" style="width: 56pt;" align="right" width="74">
8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl71" style="height: 12.75pt;" height="17"> </td> <td class="xl68" align="right">
0</td> <td class="xl68" align="right">
5</td> <td align="right">
5</td> <td class="xl69" align="right">
10</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl71" style="height: 12.75pt;" height="17"> </td> <td class="xl68" align="right">
0.5</td> <td class="xl68" align="right">
1</td> <td>
</td> <td class="xl69" align="right">
1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">
8 Total</td> <td class="xl66"> </td> <td class="xl65" align="right">
10</td> <td class="xl70" align="right">
9</td> <td class="xl67" align="right">
19</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" align="right" height="17">
8.5</td> <td class="xl65" align="right">
-1.5</td> <td class="xl65" align="right">
1</td> <td class="xl70"> </td> <td class="xl67" align="right">
1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl71" style="height: 12.75pt;" height="17"> </td> <td class="xl68" align="right">
-0.5</td> <td class="xl68" align="right">
3</td> <td align="right">
4</td> <td class="xl69" align="right">
7</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl71" style="height: 12.75pt;" height="17"> </td> <td class="xl68" align="right">
0</td> <td class="xl68" align="right">
8</td> <td align="right">
9</td> <td class="xl69" align="right">
17</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl71" style="height: 12.75pt;" height="17"> </td> <td class="xl68" align="right">
0.5</td> <td class="xl68" align="right">
1</td> <td align="right">
5</td> <td class="xl69" align="right">
6</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl65" style="height: 12.75pt;" height="17">
8.5 Total</td> <td class="xl66"> </td> <td class="xl65" align="right">
13</td> <td class="xl70" align="right">
18</td> <td class="xl67" align="right">
31</td> </tr> </tbody></table>