1. Subtotals (Excel 2002)

Hi

Subtotal(9,A1:A5) I understand the 9 in this formula = Sum and that 1= Average, Is there anywhere I can find what the numbers in between formulate ie. 2 to 8 or indeed any more if there are any more.

Not had much luck searching help or the web.

Thanks

2. Re: Subtotals (Excel 2002)

This is copied straight from the online help for the SUBTOTAL function in Excel 2002:

<table border=1><td align=center>Function_Num</td><td align=center>Function</td><td align=right>1</td><td>AVERAGE</td><td align=right>2</td><td>COUNT</td><td align=right>3</td><td>COUNTA</td><td align=right>4</td><td>MAX</td><td align=right>5</td><td>MIN</td><td align=right>6</td><td>PRODUCT</td><td align=right>7</td><td>STDEV</td><td align=right>8</td><td>STDEVP</td><td align=right>9</td><td>SUM</td><td align=right>10</td><td>VAR</td><td align=right>11</td><td>VARP</td></table>
Type subtotal in the help index or answer wizard, then select "SUBTOTAL worksheet function" to see this table.

3. Re: Subtotals (Excel 2002)

This is from the HELP under SUBTOTAL function (in XL97): [Help - contents and index - Index - "SUBTOTAL worksheet function"]
<hr>Function_Num Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP<hr>

Steve

4. Re: Subtotals (Excel 2002)

Hi Hans

Am I dumb or what, I have had my brain for 65 years and its not as good as it was!

Thanks to you and Steve

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•