Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,948
    Thanks
    2
    Thanked 1 Time in 1 Post

    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

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    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. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,948
    Thanks
    2
    Thanked 1 Time in 1 Post

    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
    If you are a fool at forty, you will always be a fool

Posting Permissions

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