Thread: Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Formula

Say your list of times is in Column A,
And the "less then" criteria (your "x") is in C1,
Then try this:

=COUNTIF(A:A,"<"&C1)/COUNT(A:A)

Format the cell you enter this formula in as a Percent.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Slinky" wrote in message
...
We are trying to get a formula to use for reponse times for our Fire

Rescue.
For a list of response times, we are trying to get a formula to tell us

what
percent of the time did we respond less than "x" amount of time. (i.e. 90%

of
the time we responded in less than 4 minutes if the times were 4, 3, 3, 3,

3,
3, 3, 3, 3, 3, 3) Thank you for any help I can get!!!