ExcelBanter - Combination of Grouping and Subtotal

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Combination of Grouping and Subtotal (https://www.excelbanter.com/excel-worksheet-functions/177939-combination-grouping-subtotal.html)

Chris

Combination of Grouping and Subtotal

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?

All times are GMT +1. The time now is 04:25 AM.