zeroing cell values in a collapsed group

D

Dave in Bradenton

I am trying to figure out how to make a group of rows cell values
become zero when collapsed and use the last entered value when
expanded. Using scenarios is too limited for the number of options I
will have. If anyone has any suggestions, I would appreciate it.
Thanks.
 
B

BrianB

I guess that you want it so the hidden values are not included in th
total. If you use =SUBTOTAL(9,"A1:A100") instead of =SUM() this will d
the job. You might even be able to use Data/Subtotals to set this up
 

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

Collapsing groups in Macro 7
collapse an expand rows using VB 7
Collapsing all groups 0
Open / Close Grouping through VBA 13
Expand/collapse toolbar ribbon 6
Code acting weird with sheets with collapsed groups 3
Controls collapsed with outline 7
Trapping expansion or collapse of outlines 1

Top