Thread: How to ignore hidden columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ismae ismae is offline
external usenet poster
  
Posts: 11
Default How to ignore hidden columns
I'd like to sum values in a row, ignoring the values in hidden columns. I
tried the SUBTOTAL function, but it appears to work only with hidden rows,
not columns. Any ideas?

Reply With QuoteReply With Quote