Thread: How do I calculate only visible data (not hidden rows)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Peter is offline
external usenet poster
  
Posts: 349
Default How do I calculate only visible data (not hidden rows)?
When I sort some data and hide rows or columns formulas are calculating using
the entire database (including hidden rows). I'd like to calculate only
'visibe' data.
Reply With QuoteReply With Quote