Raw Data

Total Time(Minutes)
5.4
6.5
5.8
8.1
5.6
6.2
4.2
5.1
6.1

From the above raw data how do I create a table as below ?

Total Time Range(Minutes) No of count
< 4 0
4.0 - 4.9 1
5.0 - 5.9 4
6.0 - 6.9 3
> 7 1

Total 9

Regards,
Tee

In B1 thru B5 enter:

=COUNTIF(A:A,"<4")
=COUNTIF(A:A,"<4.9")-COUNTIF(A:A,"<4")
=COUNTIF(A:A,"<5.9")-COUNTIF(A:A,"<5")
=COUNTIF(A:A,"<6.9")-COUNTIF(A:A,"<6")
=COUNTIF(A:A,">7")

--
Gary''s Student - gsnu2007j


"Eng Teng" wrote:

> Raw Data
>
> Total Time(Minutes)
> 5.4
> 6.5
> 5.8
> 8.1
> 5.6
> 6.2
> 4.2
> 5.1
> 6.1
>
> From the above raw data how do I create a table as below ?
>
> Total Time Range(Minutes) No of count
> < 4 0
> 4.0 - 4.9 1
> 5.0 - 5.9 4
> 6.0 - 6.9 3
> > 7 1
>
> Total 9
>
> Regards,
> Tee
>

Enter the below function into an adjacent cell, and then fill down:
=IF(A2="","",SUM($A$2:A2)-A2+1&IF(A2=1,""," - "&SUM($A$2:A2)))

Regards,
Ryan---

--
RyGuy


"Gary''s Student" wrote:

> In B1 thru B5 enter:
>
> =COUNTIF(A:A,"<4")
> =COUNTIF(A:A,"<4.9")-COUNTIF(A:A,"<4")
> =COUNTIF(A:A,"<5.9")-COUNTIF(A:A,"<5")
> =COUNTIF(A:A,"<6.9")-COUNTIF(A:A,"<6")
> =COUNTIF(A:A,">7")
>
> --
> Gary''s Student - gsnu2007j
>
>
> "Eng Teng" wrote:
>
> > Raw Data
> >
> > Total Time(Minutes)
> > 5.4
> > 6.5
> > 5.8
> > 8.1
> > 5.6
> > 6.2
> > 4.2
> > 5.1
> > 6.1
> >
> > From the above raw data how do I create a table as below ?
> >
> > Total Time Range(Minutes) No of count
> > < 4 0
> > 4.0 - 4.9 1
> > 5.0 - 5.9 4
> > 6.0 - 6.9 3
> > > 7 1
> >
> > Total 9
> >
> > Regards,
> > Tee
> >