| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I count mile times under 10:00 minutes only and get a perce
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count mile times under 10:00 minutes only and get a perce
=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 "coach" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I count mile times under 10:00 minutes only and get a p
Thanks Bob
"Bob Phillips" wrote: =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 "coach" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count times that are more than 5 minutes in a range from a newworksheet | Excel Worksheet Functions | |||
| Average minutes per mile | Excel Worksheet Functions | |||
| Adding minutes to Times | Excel Worksheet Functions | |||
| how do I calculate minutes when given two times? | Excel Worksheet Functions | |||
| how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
Linear Mode
