Sum up until empty

[Anto_BT]

excel.jpg
I have this excel, I want in column J to have.
If it is not empty to show value from I but if it is empty to Sum up until the empty one.
so in J7 it is SUM(J4:J6)

Can you help me?

[azumi]

maybe, put this on J2 and copied down

=IF(I2="","",SUM($I$2:I2))

[JohnTopley]

In J3 and copy down

=IF(I3="",SUM($I$1:I3)-SUM($J$1:J2),"")

[kvsrinivasamurthy]

Another method with ARRAY formula
In J2, then drag down.
=IF($I2<>"","",SUM(INDEX($I$1:$I1,MAX(IF($I$1:$I1="",ROW($I1:$I$2),""))-ROW($I$2)+1):$I1))
ARRAY formula is used

To enter ARRAY formula
Paste the formula
Press F2
Press Ctrl+Shift+Enter keys together.
formula will be covered with{} brackets by excel.

[Tony Valko]

How about showing us what results you expect.

[soledad]

Use this for J1 :

Please Login or Register  to view this content.

cofirm with CTRL+SHIFT+ENTER then copy down

[AlKey]

Actually this can be done with just a few key strokes without writing any formulas by hand. There is also no need for additional column. This is how it's done:
1) Press and hold Ctrl key and click on each empty cell in a column where you would want to have a subtotal amount entered.
2) Release Ctrl key and press and hold Alt key and press equal sign (=) on your keyboard.
3) Release Alt key.