kindly help to find hours as per given format

[lathish]

dear sir ma'am

ORDER ID	NO OF HOURS TO PICK
OR3173JG-002A	90
OR3289CG-002A	71
OR7846FG-002A	87
OR5531NF-003A	24
OR8259UG-001A	99
OR9663UG-001A	77
OR4926VG-001A	69
OR4421UG-001A	90
OR3805DF-002A	91
OR8570UG-001A	5
OR8533UG-001A	79
OR4675ZD-005A	71

<colgroup><col><col><col></colgroup><tbody>
</tbody>

sir/ma'am i need how much cell come under below hours


( below 24 hours) (more then 24 but below 48 hours) (more then 48/ below 72 hours) (more than 72 hours )
5 6 2 6


just a example i need to clear huge sheets kindly help

 

[arthurbr]

Try the COUNTIF and COUNTIFS functions

 

[lathish]

Sir please tell me the exact formula i have tried but its show a #name

 

[MARK858]

See column D below although your criteria doesn't allow for if it is equal to 24,48 or 72.

Excel 2010
	A	B	C	D
1	ORDER ID	NO OF HOURS TO PICK
2	OR3173JG-002A	90		1
3	OR3289CG-002A	71		0
4	OR7846FG-002A	87		3
5	OR5531NF-003A	24		5
6	OR8259UG-001A	99
7	OR9663UG-001A	77
8	OR4926VG-001A	69
9	OR4421UG-001A	90
10	OR3805DF-002A	91
11	OR8570UG-001A	5
12	OR8533UG-001A	79
13	OR4675ZD-005A	71
Sheet2

Cell Formulas
Range	Formula
D2	=COUNTIF($B$2:$B$13,"<24")
D3	=COUNTIFS($B$2:$B$13,">24",B2:B13,"<48")
D4	=COUNTIFS($B$3:$B$14,">48",$B$3:$B$14,"<72")
D5	=COUNTIF($B$5:$B$16,">72")

 

[lathish]

Sir thank u much soo help full

 

[MARK858]

You're welcome (although I did forget to make the 2nd range in D3 absolute ).