zeroing cell values in a collapsed group
 

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.

zeroing cell values in a collapsed group
 

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

--
Message posted from http://www.ExcelForum.com