how to delete rows
 

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

You can use Auto Filter ,First select all then From menu choose Data -
Filter - Auto Filter , Now you can select 0 Value from drop down of col.no.3
& then delete row .

The above process delete all row with 0 value in col.3

Sanjeev

"Khers" wrote:

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