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

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

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

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.

"Danni2004" wrote:

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