Summing dynamic range
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
|