View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carol
 
Posts: n/a
Default Ignore Hidden Rows on Sum Function on Excel XP

How do I use SUM or SUBTOTAL ignoring the hidden rows.
I have tried using 109 but it only comes up with VALUE
I am using XP Small Business