| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
times and sorting/category on all < 30 mins
I have a range of times from 11 minutes to 180 mins. I would like to be able
to know how many of these times are less than 30 minutes and also that reflected as a % of the total. How do I do This? Mike |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
times and sorting/category on all < 30 mins
With your range of values in column A,
This will tell you how many are less than 30...... =COUNTIF(A:A,"<30") This will tell you that percentage of the total...... =COUNTIF(A:A,"<30")/COUNT(A:A) format as Percent Vaya con Dios, Chuck, CABGx3 "MikeR-Oz" wrote: I have a range of times from 11 minutes to 180 mins. I would like to be able to know how many of these times are less than 30 minutes and also that reflected as a % of the total. How do I do This? Mike |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
times and sorting/category on all < 30 mins
Appreciate that CLR- simple and effective. Is there also a way of
Highlighting those numbers / cells that are over the 30 minutes and whats the formulas for == to and < than the 30 mins to be captured? Mike "CLR" wrote: With your range of values in column A, This will tell you how many are less than 30...... =COUNTIF(A:A,"<30") This will tell you that percentage of the total...... =COUNTIF(A:A,"<30")/COUNT(A:A) format as Percent Vaya con Dios, Chuck, CABGx3 "MikeR-Oz" wrote: I have a range of times from 11 minutes to 180 mins. I would like to be able to know how many of these times are less than 30 minutes and also that reflected as a % of the total. How do I do This? Mike |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
times and sorting/category on all < 30 mins
To highlight those cells over 30,.....highlight the cells, and do Format
ConditionalFormatting CellValueIs GreaterThan 30 Format choose the format preferred ok ok............ To alter your formulas so they will accomodate both "less than" and "equal to" 30......... =COUNTIF(A:A,"<=30") =COUNTIF(A:A,"<=30")/COUNT(A:A) Vaya con Dios, Chuck, CABGx3 "MikeR-Oz" wrote: Appreciate that CLR- simple and effective. Is there also a way of Highlighting those numbers / cells that are over the 30 minutes and whats the formulas for == to and < than the 30 mins to be captured? Mike "CLR" wrote: With your range of values in column A, This will tell you how many are less than 30...... =COUNTIF(A:A,"<30") This will tell you that percentage of the total...... =COUNTIF(A:A,"<30")/COUNT(A:A) format as Percent Vaya con Dios, Chuck, CABGx3 "MikeR-Oz" wrote: I have a range of times from 11 minutes to 180 mins. I would like to be able to know how many of these times are less than 30 minutes and also that reflected as a % of the total. How do I do This? Mike |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
times and sorting/category on all < 30 mins
If you mean the formula for less than and equal to replace < with <= in the formula For formating the cells select the cells goto format conditional formating, select cell value is, select condition, 30 and then click on the format button to choose whatever format appeals to you! Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=507201 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
