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

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

Try:

=COUNTIF(A5:J5,"<4")/COUNT(A5:J5)

and format as percentage
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"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!!!

try this idea
=SUMIF(I2:I20,"<4")/SUM(I2:I20)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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!!!

Don,

That returns 87.1% with the OP's data and the faster that their response
times are after the initial 4, the worse the % gets.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Don Guillett" wrote in message
...
try this idea
=SUMIF(I2:I20,"<4")/SUM(I2:I20)

--
Don Guillett
Microsoft MVP Excele
SalesAid Software

"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!!!

Thank you to all for your very quick response. It worked!!!

"Slinky" wrote:

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

Obviously, I meant count instead of sum? Gettin old is hell

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sandy Mann" wrote in message
...
Don,

That returns 87.1% with the OP's data and the faster that their response
times are after the initial 4, the worse the % gets.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Don Guillett" wrote in message
...
try this idea
=SUMIF(I2:I20,"<4")/SUM(I2:I20)

--
Don Guillett
Microsoft MVP Excele
SalesAid Software

"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!!!

And we all appreciate your feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Slinky" wrote in message
...
Thank you to all for your very quick response. It worked!!!

"Slinky" wrote:

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