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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top