| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Combining an IF function and Median Function
I have a list of 3288 items, I want to find the median of FCFY those items with a p/e value greater than one. There are 2 columns: p/e value and FCFY.
I think the formula should look like this but it doesn't work.. =IF(B4:B32881,MEDIAN(C4:C3288)) English: Find the median of C's value for all B's that are greater than 1. Thanks for your help!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median If Function | Excel Worksheet Functions | |||
| Median Function | Excel Discussion (Misc queries) | |||
| median function | Excel Worksheet Functions | |||
| median function | Excel Worksheet Functions | |||
| Median function | Excel Discussion (Misc queries) | |||
Threaded Mode
