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

D

Danni2004

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
 
B

BoniM

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

Getting Text data using the Data - Subtotal feature 1
Pivot Table Formula Problem 1
description of count in subtotal 1
Subtotal 0
Subtotal by Date and Summary in Lists? 0
Counting Subtotal 4
subtotal within subtotal 5
Multiple formulas in subtotal 2

Top