Why not add a subtotal using countA for the Product column?

When you apply data|subtotals, you can still use Sum as your function, but
include the product column.

Since you're summing, all your:
=subtotal(9,Bx:By)
will be 0's (assuming that all your product codes are text).

So select column B and then
edit|replace
what: (9,
with: (3,
replace all

Then you can use that subtotal in your formula.

I don't know if this will work, since you haven't shared the formula.

KG wrote:

the problem I'm having is that:

1) One of the formulas I am using is counting the total number of items that
make up the subtotal and
2) the number of items that go into the subtotal varies widely; for example,
one subtotal may be from a list of 5 items whereas the next may be from a
list of 45.

I don't see how I can copy and paste a formula that computes a range of 5
items to the next subtotal that is composed of a much larger number of items.

"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