I don't think there is a formula that can delete rows, but you can create another column with a SUM function.

Afterwards, use a filter on that column to only show zero values. Then you can just select the rows and delete them.