Combination of Grouping and Subtotal

C

Chris

I've created a worksheet with several numbers grouped under a top level item.
I would like the top level item to display zero when the cells are expanded
and then to roll up or subtotal the numbers below it when condensed. The
subtotal 109 function behaves exactly opposite of what I'm trying to do. Any
suggestions?
 

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
Need array formula to ignore hidden values 1
Formulas in subtotal worksheets? 3
Excel 2007 - Outline not displaying all nested subtotals 0
subtotals function error 2
summing adjacent data in a worksheet 3
Subtotal Function - add formula to all blank rows 1
subtotals 1

Top