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
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online