Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and Percentile
I am trying to combine . Does anyone know if this can be done? I got a
result with the following: =PERCENTILE(SUMPRODUCT((C1:C10="Green")+(E1:E10="C at")),0.9) =SUMPRODUCT(--(C1:C10="Green"<PERCENTILE(C1:C10,0.5)),--(E1:E10="Cat"<PERCENTILE(E1:E10,0.95))) =PERCENTILE(SUMPRODUCT((C1:C10=12)+(E1:E10=75)),0. 9) Initially I thought, ok, maybe I can't calculate a percentile on text, but I still thought Excel would calcualte the percentile of the matching values. Maybe it requires Percentile & Index & Match? Anyway, I tried a few things and I'm not getting the results I expected... Maybe this can't be done... Can anyone confirm, comment, etc. -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
to get its k-value from percentile and array | Excel Worksheet Functions | |||
Conditional Percentile | Excel Discussion (Misc queries) | |||
?Percentile? Graph | Charts and Charting in Excel | |||
percentile | Excel Worksheet Functions | |||
Percentile function | Excel Worksheet Functions |