how to delete lines

[macedo]

Good night

I would like to know which formula shall I have to write in order to delete lines whose sum is zero (0).

Thank you

José Macedo

[haru]

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.

[macedo]

Thanks
I have already create a column with sum and I have used already that filter. However, in other foruns there are some references to a formula using more or less this:
=and(isnumber(a1), sum(b1:E1)=0
Do you know these formulas?
Thank you very much again
Jose

[darknation144]

Do actually delete a line you would need to use VBA there is no excel formula that can invoke the delete command.