| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Quartile and multiple if
I want to do median with multiple columns criteria.
If B2:B1000=2 AND If C2:C1000=20006 QUARTILE(D2:D1000) The below returns an error. What am I missing? Thanks in advance. =QUARTILE(IF(AND(B$2:B$1000=2,C$2:C$1000=2006),D$2 :D$1000,1),0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup to return count, median, lower quartile, upper quartile&ave | Excel Discussion (Misc queries) | |||
| Quartile funciton...quintile? | Excel Discussion (Misc queries) | |||
| Condtional Quartile statement | Excel Worksheet Functions | |||
| Quartile / Quintile Function | Excel Worksheet Functions | |||
| Quartile Function | Excel Discussion (Misc queries) | |||
Threaded Mode
