+ Reply to Thread
Results 1 to 4 of 4

Getting Excel Not To See Certain Things for Averages

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    California
    MS-Off Ver
    Excel for Mac 2011
    Posts
    1

    Getting Excel Not To See Certain Things for Averages

    Hello,

    I'm not experienced with Excel, and I have a question. I have a form and there is drop down boxes to sort various information. Its an attendance form, and for instance we can sort to just show Wednesday, etc. Well when we want to average out totals for just a Wednesday, Excel sees all the other data for every other day as well. Is there a way to fix this? Thanks.

  2. #2
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Getting Excel Not To See Certain Things for Averages

    Please Login or Register  to view this content.

  3. #3
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Getting Excel Not To See Certain Things for Averages

    You can perform functions on filtered ranges using the Subtotal Function.
    Average would be:

    =SUBTOTAL(1,A1:A10)

  4. #4
    Forum Contributor bentleybob's Avatar
    Join Date
    02-27-2009
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2010
    Posts
    644

    Re: Getting Excel Not To See Certain Things for Averages

    davegugg is, of course, correct. I was assuming you wanted to have your averages work regardless of what's filtered. Both methods work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1