zeroing cell values in a collapsed group

  • Thread starter Thread starter Dave in Bradenton
  • Start date Start date
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.
 
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
 
Back
Top