Hi again,

Am Sat, 6 Dec 2014 03:35:07 -0800 (PST) schrieb L. Howard:

There would also be a total row at the bottom of the data, in row 37, it would total the Class 44 data in this example.

I have two additional questions:

1. Don't you need in $ column the sumproduct of units and price?

2. Is each 5th column empty? If so, it is easier to write formula and
format through AB:CK and delete it in each 5th column instead of looping
through the cells


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