You could use Autofilter and select "is greater than"

Data Filter Autofilter

Click on the filter arrow on the Quantity Column and select:

Custom and select "is greater then" and zero from the arrow dropdowns.

You can then copy and paste the data without the zeros.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Lost in excel" <Lost in wrote in message
...
I need help which is probably basis to most of you, thanks in advance

I have a spreed sheet with this type of data

Item Quantity Price Total
xxx 23 $64 xxxx
xxx 0 $74 xxxx
xxx 14 $222 xxxx

What I would like to do is be able to create a seperate spreed sheet that
only counts the items that total over 0. Is this possible

Thanks

jim