kindly help to find hours as per given format

[lathish]

dear sir ma'am

[TABLE="width: 436"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]ORDER ID [/TD]
[TD]NO OF HOURS TO PICK [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OR3173JG-002A[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR3289CG-002A[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR7846FG-002A[/TD]
[TD="align: right"]87[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR5531NF-003A[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR8259UG-001A[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR9663UG-001A[/TD]
[TD="align: right"]77[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR4926VG-001A[/TD]
[TD="align: right"]69[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR4421UG-001A[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR3805DF-002A[/TD]
[TD="align: right"]91[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR8570UG-001A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR8533UG-001A[/TD]
[TD="align: right"]79[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]OR4675ZD-005A[/TD]
[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]


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 ).