Selecting data for report

[Lost in excel]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Roger Govier]

Hi Jim

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