Formula

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

Guest

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top