View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Subtotal and Auto-filter

I need to find a percentage of 2 columns using auto-filter. The first colum
formula is

=SUBTOTAL(9,F3:F5000)]

The second column is

=SUBTOTAL(9,G3:G5000)


Anyone wanna help...also how the formula works so I don't need to ask dumb
questions....