Thread: How do I get "auto sum" to subtract hidden cell values from total
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default How do I get "auto sum" to subtract hidden cell values from total
Yes. Look at the function SUBTOTAL in help. That function can exclude
manually hidden rows from totals.

Tyro

"Marsha" wrote in message
...
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?


Reply With QuoteReply With Quote