Subtotals Deborah 12/30/2008 1:58:01 PM What does the 9 in this formula mean "=SUBTOTAL(9,J2:J105)"?

Re: Subtotals "Bernard Liengme" <bliengme[ at ]stfx.TRUENORTH.ca> 12/30/2008 2:10:35 PM The syntax is =SUMTOTAL(function_number, reference_1, [reference_2]....) The function_number arguments informs Excel what you require of SUBTOTAL as shown in the table below taken from Help. The value 9 means you want to SUM (rather than count, average, etc) and as it is a single digit you want to the sum to include any hidden values. Function_num (includes hidden values) Function_num (ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM 10 110 VAR 11 111 VARP best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Deborah" <Deborah[ at ]discussions.microsoft.com> wrote in message news:94D40C9A-7C8D-4EE3-BBAB-1C93E57ECF7F[ at ]microsoft.com... [Quoted Text] > What does the 9 in this formula mean "=SUBTOTAL(9,J2:J105)"?

Re: Subtotals "David Biddulph" <groups [at] biddulph.org.uk> 12/30/2008 2:30:17 PM As far as I can see, the Excel Help for the SUBTOTAL function makes it perfectly clear. Have you looked at Help? Was there something there which you didn't understand? -- David Biddulph "Deborah" <Deborah[ at ]discussions.microsoft.com> wrote in message news:94D40C9A-7C8D-4EE3-BBAB-1C93E57ECF7F[ at ]microsoft.com... [Quoted Text] > What does the 9 in this formula mean "=SUBTOTAL(9,J2:J105)"?

RE: Subtotals Shane Devenshire 12/30/2008 4:13:00 PM Hi, Actually the 9 means two things: 1. The operation you want to perform is SUM and 2. The entries you want to sum are hidden via the AutoFilter command, not by manually hidding the rows or collapsing groups (as in the Subtotal command). 3. If you want to sum only visible cells choose 109 instead of 9. Then it doesn't matter how you hide the rows. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Deborah" wrote: [Quoted Text] > What does the 9 in this formula mean "=SUBTOTAL(9,J2:J105)"?