Devam Ediyor

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

This

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: 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

İşveren Hakkında:
( 13 değerlendirme ) Rome, Italy

Proje NO: #2239946

1 freelancer bu iş için ortalamada 20$ teklif veriyor

theincredible

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

in 0 gün içinde20$ USD
(106 Değerlendirme)
6.2