if function to delete rows

K

Khers

I have a work sheet that has many rows like this and 3 coloums
1 chair custom 24
2 table custom 0
3 spoon custom 3563
4 hat custom 0

now I would like to make another colom and only extract those that
their sum is greather than zero. in other words I would like to delete
rows 2 and 4
how can i do that using if-function or any other function

tnx
khers
 
R

Roman

You can use filter (Data / Filter / Autofilter ) to filter the rows
having sum equal to zero, then select them and delete them
 
Top