Results 1 to 5 of 5

Average of each 25% of column

Threaded View

rakker Average of each 25% of column 06-18-2011, 09:57 AM
rakker Re: calculating average from... 06-19-2011, 07:03 AM
rakker Re: calculating average from... 06-19-2011, 09:39 AM
daddylonglegs Re: Average of each 25% of... 06-19-2011, 12:09 PM
rakker Re: Average of each 25% of... 06-19-2011, 12:41 PM
  1. #1
    Registered User
    Join Date
    06-18-2011
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    12

    Average of each 25% of column

    Bumping an old topic, cause I have the some problem.
    How do I calculate the second 25%, the third 25% and last 25% of an range in a column?
    With some trial and error I came to this:

    second 25%:
    AVERAGE(OFFSET(A1,INT(COUNT(A1:A10000)/4),0,INT(COUNT(A1:A10000)/4),1))

    third 25%:
    AVERAGE(OFFSET(A1,INT(COUNT(A1:A10000)/2),0,INT(COUNT(A1:A10000)/4),1))

    last 25%:
    dont have yet

    Is any of this good?
    Can someone plz show me the correct formulas?
    Perhaps also the formulas for first, second, third, fourth and last 20% of an range?
    Last edited by rakker; 06-18-2011 at 10:03 AM. Reason: typo

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