View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hommer
 
Posts: n/a
Default sum only visible cells

Hi, all!
Is there a way to sum just the visible cells in a range?
Excel lets one copy or select only visible cells. Can I use an IIF to test a
cell is hiden or not then decide if it should be included in the calculation?

Thanks!