so I have task where I want to make google sheet 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))