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