How can I do a count subtotal AND a sum subtotal on the same row?

G

Guest

Can anyone help me figure out how to subtotal data so that I can get a sum of
each group AND a count of the same group?

Thanks in advance
 
G

Guest

Assuming you're using the subtotal command from the Data menu, when you make
your selection for the second entry, remove the check from the Replace
current subtotals check box.
 

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

Conditional SUBTOTAL in XL210 Table 7
Getting Text data using the Data - Subtotal feature 1
Pivot Table Formula Problem 1
subtotal within subtotal 5
description of count in subtotal 1
Counting Subtotal 4
Cell Protection - Subtotal 1
Excel Subtotal without calculate duplicate lines 4

Top