Marv,

No, my question is how, when you

"want to copy the formula down to the next "grouping" of cell data (locations), the
number of cells calculated changing with each grouping"

How do you tell what is a group - blank lines, another column with a value like "Group 1" "Group
2", ESP perhaps?

HTH,
Bernie
MS Excel MVP


"MarvInBoise" wrote in message
...
It's always column E that has the absolute reference, if that's your
question; and thanks for the response!
--
Marv Lusk
Boise Corporation


"Bernie Deitrick" wrote:

Marv,

Is there a column of values that determines the groupings?

HTH,
Bernie
MS Excel MVP


"MarvInBoise" wrote in message
...
An example of a formula I have is: =SUMPRODUCT($E$23:$E$29*F23:F29)/$E$30. I
copy/fill the formula to the right, which works fine; however, I then want to
copy the formula down to the next "grouping" of cell data (locations), the
number of cells calculated changing with each grouping, e.g., the above has a
7 cell range but the next group might have 3 and then the next might have 12,
etc.,
etc., for many, many groupings, so it ends up being a lot of manual changing
of formulas.

Any help is greatly apprecaited. Thanks!
--
Marv Lusk