View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
psill psill is offline
external usenet poster
 
Posts: 3
Default Need to sum columns, excluding hidden columns.

I need to sum a row spanning several columns where some of the columns are
hidden. I need to have the hidden columns excluded from the total. Is there
a function that will do that similar to how 'subtotal' works for rows?