How to write such a formula?

In other words it stops summing the #s when the column header is encountered. There may be multiple column headers. Thanks!