| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function
Another question now: I want to count the number of cells in the column I
mention below that are below the 95th percentile only if on another column in that same row the value there is below its 95th percentile. Basically I have two columns containing stock returns. I want to calculate the number of times both stocks return an amount below their 95th percentile return on the same day. Maybe that makes it easier to understand. Thanks again |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif function
Never mind, I figured it out.
=SUMPRODUCT(--(C3:C263<PERCENTILE(C3:C263,0.95)),--(AC3:AC263<PERCENTILE(AC3:AC263,0.95))) worked for me. Thanks anyway. "Charles" wrote: Another question now: I want to count the number of cells in the column I mention below that are below the 95th percentile only if on another column in that same row the value there is below its 95th percentile. Basically I have two columns containing stock returns. I want to calculate the number of times both stocks return an amount below their 95th percentile return on the same day. Maybe that makes it easier to understand. Thanks again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| CountIf Function Question | Excel Discussion (Misc queries) | |||
| CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
| can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Linear Mode
