Subtotaling in Excel Using Different Types of Calculations

Is there a way to subtotal the details (records) in an
Excel list where all of the subtotals appear on the same
row, but row details (records) are subtotaled using
different functions, e.g., sum, count, average, etc.?
When using the Data and Subtotal automatic features, the
different types of subtotals appear on separate rows.

Thanks.

Instead of using Subtotals, you could experiment with a PivotTable. It's
designed to summarized data from a table, and may give you the layout
that you want.

There's information in Excel's Help, and links to more information he

http://www.geocities.com/jonpeltier/...pivotstart.htm

GBO wrote:
Is there a way to subtotal the details (records) in an
Excel list where all of the subtotals appear on the same
row, but row details (records) are subtotaled using
different functions, e.g., sum, count, average, etc.?
When using the Data and Subtotal automatic features, the
different types of subtotals appear on separate rows.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html