Hi Howard,

Am Fri, 5 Dec 2014 17:12:46 -0800 (PST) schrieb L. Howard:

If you will click the "Class row" row button then enter a 1 in the box, you will see a row inserted at the change of each class value. I have a code line that simulates adding the formulas in the data field, it puts "XX" in the first group of four columns.

Each XX will need to be a formula (or the result of a formula) to add the cells above it to up to the next class break.

please explain a little more. I understand to insert a row on class end
to sum the class items. But what should happen if you insert more than
one row? Then you make a sum out of the class items and the sum in the
row above. The second sum is twice the first sum. The third sum is twice
the second sum and so on. What is the reason behind?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional