Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
With your values to be summed in column D, enter in E2 =IF(D2<"","",SUM($D$1:D1)-SUM($E$1:E1)) copy down column E as far as required -- Regards Roger Govier "Vlado Sveda" wrote in message ... That's the problem I need to solve. I need to sum all cells above the "Sum cell" in continuous range - as described in my example. "bj" wrote: How do you identify which rows to sum? "Vlado Sveda" wrote: Let imagine this situation: I have column with set of ranges and I need to sumarise every particular range. for example: D4: 9 D5: 5 D6: 3 D7: =SUM(D4:D6) D8: D9: 1 D10: 2 D11: 3 D12: =SUM(D9:D11) D13: D14: 1 D15: 1 D16: 1 D17: 1 D18: 1 D19: 1 D20: 1 D21: =SUM(D14:D20) etc .... My Idea is have in every "Sum cell" the same formula. Every single range can vary in mumber of rows. In VBA I can use .CurrentRegion.Rows.Count. Is something similar possible in sheet formulas ? Thanks in advance to all ! Vlado |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
summing name range in the same column with Dynamic name ranges | Excel Worksheet Functions | |||
Summing between Range | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Summing a range that changes | Excel Discussion (Misc queries) | |||
dynamic summing of an autofilter 'ed table | Excel Discussion (Misc queries) |