View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in excel Lost in excel is offline
external usenet poster
 
Posts: 9
Default Selecting data for report

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