Subtotaling in Excel Using Different Types of Calculations

G

GBO

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use the subtotal function while a worksheet is protected? 0
Unmatched rows 0
Need array formula to ignore hidden values 1
Excel 2007 - Outline not displaying all nested subtotals 0
Getting Text data using the Data - Subtotal feature 1
Macro Pause to Select range then Subtotal 0
Calculating subtotals 0
Don't show all Pivot table subtotals 1

Top