Select your data range, then DataSubtotals (from the main menu)..experiment
with the settings until you get what you want.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"Stewart" wrote:

My spreadsheet is downloaded as:

006 02 $1.00
006 02 $1.00
006 03 $1.00
006 03 $1.00
007 02 $1.00
007 02 $1.00
007 03 $1.00
007 03 $1.00
What I need to do is put a space in between the changes in column 2 and sum,
end result:

006 02 $1.00
006 02 $1.00
(02 Sum of 006) $2.00
006 03 $1.00
006 03 $1.00
(03 Sum of 006) $2.00
007 02 $1.00
007 02 $1.00
(02 Sumof 007) $2.00
ETC.......
How do I have it insert the row at the changes in Column 2 and sum in the
last row?