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

C

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
 
B

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"))
 
C

coach

Thanks Bob

Bob Phillips said:
=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
Click to expand...
 

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

How do I count a range of times and link it another worksheet. 3
How do I calculate time in excel (clock in and clock out 3
count records in a date range 3
How do I count instances that fall within time bands? 0
Finding if a certain time falls between two other times: 1
Help please to get times of date into a graph 2
Count Based On Multiple Criteria 2
how to i change times in one note daily calendar 1

Top