Help, please.

My spreadsheet has 30 columns, 800 rows populated with budget hours.

I need a search by row to find a negative number (starting at column 30) and
then SUM that value from the cells to the left until the sum equals 0 or a
positive number.

TIA

Dpingger