How do I count mile times under 10:00 minutes only and get a perce

[coach]

I need a formula to count only mile times that are under 10:00 and possible
get a percentage to be able to chart it by class
example
name Mile Times
John 12:00
Suzy 8:00
Chris 11:00
Dillon 9:00
Jack 7:23
Rod 10:30
Missy 9:27
Jane 12:30

In this example I need an answer of "4" students made the time limit of
under 10 min and 50% of the class were under 10min. And I want to be able to
graph it compared to other classes.



Also is it possible to count males and females times with males set at 10min
and females at 11min

thanks

 

[Bob Phillips]

=COUNTIF(B2:B9,"<=10:00:00")

to count male and females, you need another cilumn showing sex, and use
SUMPRODUCT

=SUMPRODUCT(--(B2:B9="F"),--(C2:C9<=--"11:00:00"))

 

[coach]

Thanks Bob

=COUNTIF(B2:B9,"<=10:00:00")

to count male and females, you need another cilumn showing sex, and use
SUMPRODUCT

=SUMPRODUCT(--(B2:B9="F"),--(C2:C9<=--"11:00:00"))

--
__________________________________
HTH

Bob