Thread: SUBTOTAL and 9
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default SUBTOTAL and 9

Hi,

In a table with subtotals we can see a formula like =SUBTOTAL(9,B4:B10)
irrespective of the number of rows. What is the importance of this "9"? Can
anybody explain?

Thanks & Regards,

Jaleel