Hi,

You can also use a pivot table. Drag the columns of numbers in the data
area and row input area. Now on the pivot table toolbar, click on Group and
supply the 3 inputs in the box

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"keerthyV" wrote in message
...
hi,

Please guide me,
I have numeric data,
61
62
72
34
33
50
30
34
39
60
74
71
54
57
61
67
65
69
58
56
41, i want this data in ranges like 30-40,40-50,50-60,60-70,70-80,..

That is in the above data, range 30-40 will be 170(Sum of the values)

It will be helpful, as i work on large set of numerics max.

Keer