View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marsha Marsha is offline
external usenet poster
 
Posts: 6
Default How do I get "auto sum" to subtract hidden cell values from total

When I have a column or row of cells "auto summed" at the end I want to be
able to hide certain colums/rows in that sequence and have the hidden cell
values automatically deducted from the sum. Is that possible?