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

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

Hi Jim

I assume you want the result on Sheet2.
=COUNTIF(Sheet1!D:D"0")

--
Regards
Roger Govier

"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