| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
