If the number of subtotals is small, maybe you could just do the formulas for
one row (multiple cells worth of formulas???).

Then copy those cells
select the next visible row (next subtotal line) and ctrl-v

down arrow
ctrl-v

down arrow
ctrl-v

(and so forth)

====
Or modify your formulas....

Look for a key (Like the word Total in the key column)

I'd show all the rows and use a formula like:
=IF(ISERROR(SEARCH("total",A2)),NA(),"yourformulah ere")
and drag down

Then select that column
edit|goto|special
check Formulas
and keep errors checked, but uncheck Numbers, Text, Logicals.
Then hit the delete key to clear contents of those error cells.

========
On the other hand, you may want to play around with pivottables.

After you create the pivottable, maybe using some of the techniques at Debra
Dalgleish's site would come in handy:

http://www.contextures.com/xlPivot10.html



KG wrote:

I have a large data list with subtotals (in fact with nested subtotals). I
have collapsed the list so that only the subtotals are showing. Next I set up
a few columns to the right of the data list with the intent of applying
certain calculations, again ONLY to the subtotals.

Here lieth the problem: when I set up the formulas for the first subtotal
and attempt to simply drag it down, Excel obviously assumes that the copied
formula applies to the next row of the full-blown, uncollapsed data list. Is
there any way to accomplish the task without having to manually create a
separate table that only displays the subtotaled data? That would be a very
big (and boring) job. Incidentally the row interval between subtotals varies
widely.

--

Dave Peterson