In Progress

494032 Excel formula help needed

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


Skills: Anything Goes, Excel

See more: works need excel, i need help with excel, formula it, excel help needed, percentile excel, excel help formula, need help with excel, need help excel, excel function, excel formula, excel excel 2010, need formula, excel sample file, sample excel worksheet, average function, excel formula calculate time, simple excel formula, calculate average, worksheet excel, worksheet function, file series excel, excel 2010, find values excel, time worksheet excel, excel worksheet data

About the Employer:
( 13 reviews ) Rome, Italy

Project ID: #2239946

1 freelancer is bidding on average $20 for this job


Immediately Sir, i can do it in excel only, please see PMB...

$20 USD in 0 days
(106 Reviews)