After posting my last message I started thinking that perhaps a Pivot Table
may be the way to go rather than macros.

If you wish to have a go at that, see Debra Dalgleish's site for mucho help.

http://www.contextures.on.ca/tiptech.html

Look under "P" for Pivot Tables.

I still can't quite reconcile your posted COUNTIF/COUNT formula with your
description.

Does column C remain a constant divisor for H, J and K?

Can you send me the workbook?

email to gorddibbATshawDOTca Change the obvious.


Gord

On Mon, 2 Nov 2009 15:24:01 -0800, randlesc
wrote:

Thanks once again.

H has the data, the formula goes into I
J has the data, the formula goes into K

There are easier ways to do this, I know but I have no choice. It must be
in the set up administration designed--don't get me started on how I feel
about this decision.

Thanks.

"Gord Dibben" wrote:

In which columns and cells would you want the formulas?

I am not clear about H, I then J, K

Maybe you would want formulas inserted into a row below each grouping?

Instead of a pagebreak?


Gord