+ Reply to Thread
Results 1 to 2 of 2

Pulling averages from a specified range of numbers

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    57

    Pulling averages from a specified range of numbers

    I have a document that I need to categorize and provide the average rates for certain sub groups. For instance In the sheet I need to take the average response rate or "R.R." for companies based off their eligibles. But I need companies whos eligibles fall in to the given eligible bracket to be calculated only. So for instance companies that are less than 5,000 eligibles (main data table) need to be the only ones factored in when getting the average response rate (R.R.) for the less than 5,000 eligible bracket.

    Any ideas? Thanks,

    Rob
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Pulling averages from a specified range of numbers

    do you want to average the averages in column F

    you can use an average IF
    =AVERAGEIF(C2:C15,"<5000",F2:F15)

    you could use indirect to pickup the value a19 if needed
    =(AVERAGEIF(C2:C15,INDIRECT("A19"),F2:F15))

    for the next row
    do you need to do between 5000 and 20,000
    =AVERAGEIFS(F2:F15,C2:C15,">=5000",C2:C15,"<=20000")
    Last edited by etaf; 06-12-2013 at 02:09 PM.

+ 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