View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
keerthyV keerthyV is offline
external usenet poster
 
Posts: 3
Default summing to defined ranges

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