summing to defined ranges

[keerthyV]

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

 

[T. Valko]

i want this data in ranges like 30-40,40-50,50-60,60-70,70-80,..

Well, the first thing you need to do is eliminate the overlaps. Perhaps you
meant:

30-39,40-49,50-59

To sum the values in the 30-39 range (inclusive):

=SUMIF(A1:A21,">=30")-SUMIF(A1:A21,">39")

Better to use cells to hold the criteria:

C1 = 30
D1 = 39

=SUMIF(A1:A21,">="&C1)-SUMIF(A1:A21,">"&D1)

 

[Ashish Mathur]

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