summing to defined ranges
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)
--
Biff
Microsoft Excel MVP
"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
|