View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DianeG DianeG is offline
external usenet poster
 
Posts: 59
Default Sum visible cells only

Hi

Is there a way to sum visible cells only without using a pivot table? Some
values are sitting in hidden columns and they still add up, I'd like them to
be ignored

Thanks

Diane