Forum home » Delegate support and help forum » Microsoft Excel Training and help » Subtotals
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Subtotals
Resolved · Low Priority · Version 2007
Reply Tue 21 Jun 2011, 15:06Delegate John said...
For upcoming training course dates see: Pricing & availability
RE: 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
Tue 28 Jun 2011: Automatically marked as resolved.
|