How to auto sum upwards until no number is found?-CodePudding

Home > Software design > How to auto sum upwards until no number is found?

How to auto sum upwards until no number is found?

Time：07-02

I want to make a cell auto calculate all numbers above until there is no number (in my example until it meets merged cell "TEXT ROW").

For better understanding there is screenshot:

Please let me know if you have any issues with this.

CodePudding user response：

try:

=SUM(INDIRECT(ADDRESS(COLUMN(), 2, 4)&":"&ADDRESS(COLUMN(), ROW()-1, 4)))

or:

=SUM(INDIRECT("E2:E"&ROW()-1))