Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
Create new list with defined ranges | Excel Worksheet Functions | |||
Summing cells defined as Time hh:mm | Excel Discussion (Misc queries) | |||
dynamic defined ranges | Excel Worksheet Functions | |||
How do I group data using defined ranges? | Excel Worksheet Functions |