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
|