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 |
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 |
summing to defined ranges
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 |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com