Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing dynamic range
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 | |
|
|
Similar Threads | ||||
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) |