countif function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for growth chart? 5
I think it is a lookup question??? 6
countif function 4
PERCENTILE exceeding 8191 points 1
logical functions utilizing percentiles 7
A Percentile IF function 1
Ugly Problem 1
Returning all data from a list above the nth percentile 11

Back
Top