494032 Excel formula help needed

This project received 1 bids from talented freelancers with an average bid price of $20 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
Total Bids
Project Description

I need help with an Excel 2010 worksheet. I have calculated the n-Percentile of a data series. Now I need to find a way (preferably a formula) that can calculate an average on the values of the data series but only if they fall within some of the Percentiles.

Since I have many data series (thousands), I need something that works automatically. The problem with the Averageif function is that the criteria cannot be referenced to cells. This means that I should enter the Percentiles as criteria in the averageif function for every data series. It will take too much time and result in a mess.

Any workaround or solution ? MUST BE EXCEL..and very simple too.

Thanks See sample file, please


Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online