Subtotals

Hi John,

It works as you expect:

=PRODUCT(SUBTOTAL(2,$D$15:$D$2169),SUBTOTAL(1,$D$15:$D$2169))

will multiply the count of a field by the average of a field of a filtered database - effectively giving the answer you would have achieved with

=SUBTOTAL(9,$D$15:$D$2169)

It would also work across 2 different databases, if you were applying filters to both. Remembering where you were with each filter might be tricky though...

Hope this answers the question!

Clare Glover