Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with Average Function (2003)

    Greetings,

    Had help with a subtotal function a while back.

    Background: I have a worksheet where I have set autofilters on. The Subtotal function works great to show me the total of items displayed when I filter the data. I would like to do the same with the Average function.

    Current for the Subtotal =SUBTOTAL(3,C4:C328)

    Current for the Average =AVERAGE(E4:E243)

    any ideas?

    Thanks,
    Brad

  2. #2
    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: Help with Average Function (2003)

    =Subtotal(1,E4:E243)

    [You might want to look at SUBTOTAL in the Help as it indicates the "function numbers" needed to give different statistical functions...]

    Steve

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with Average Function (2003)

    Steve,

    Thanks! Just looked at the help. did not even think to go there (or use subtotal function for average).


    Brad

  4. #4
    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: Help with Average Function (2003)

    Yes the "subtotal" is a little bit of a misnomer, but you should have guessed that when you used it to COUNT rather than to SUM... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    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
  •