Spreadsheet: 96402d1295816829-listing-of-selective-data-advfilterexample
Sheet: Sheet1

 |  |  | Source list
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sum =
 |  |  | Name | Amt | Del. | INV. | Open | Diff. |  |  | Name | Amt | Del. | INV. | Open | Diff. |  | Name | Amt | Del. | INV. | Open | Diff.
blank rows contain details |  |  |  |  |  |  |  |  |  |  | abc |  |  |  |  | >0 |  | abc | 68136.2 | 2010-01-07 00:00:00 | 656 | 7.275957614183426e-11 | 614
that add up to the total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abc | 77515.19 | 2010-01-30 00:00:00 | 660 | 0 | 698.31
on this line |  |  | abc | 68136.2 | 2010-01-07 00:00:00 | 656 | 7.275957614183426e-11 | 614 |  |  |  |  |  |  |  |  |  | abc | 122986.64 | 2010-03-10 00:00:00 | 667 | -3.492459654808044e-10 | 1107.98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | abc | 57672.22 | 2010-07-22 00:00:00 | 694 | -1.891748979687691e-10 | 662.42
these details are not relevant |  |  |  |  |  |  |  |  |  |  | The Above is the Criteria Range (L3:Q4)
for making the target list |  |  |  |  |  |  |  |  |  |  | The Headings need to be exactly like your data
 |  |  |  |  |  |  |  |  |  |  | Your data is from D3:I37
 |  |  | abc | 77515.19 | 2010-01-30 00:00:00 | 660 | 0 | 698.31
 |  |  | def | 9800 | 2010-01-30 00:00:00 |  | 0 |  |  |  | After creating the Criteria range above and putting in abc and >0
 |  |  |  |  |  |  |  |  |  |  | Find click Advanced Filter - A dialog box will show
 |  |  | mno | 16452.78 | 2010-07-05 00:00:00 | 655 | 7.457856554538012e-11 | 170.66 |  |  | Fill it in with Data range of D3:I37
 |  |  |  |  |  |  |  |  |  |  |  | Criterial Range of L3:Q4
 |  |  |  |  |  |  |  |  |  |  | Then click on the Copy to Another Location radio button
 |  |  |  |  |  |  |  |  |  |  | In the Copy To range put S3 and click OK
 |  |  | ghi | 151911.6 | 2010-03-13 00:00:00 | 668 | 151911.6
 |  |  |  |  |  |  |  |  |  |  | This will give you the answer in the above Right Table
 |  |  |  |  |  |  |  |  |  |  | I hope this helps.  You don't really need a formula.
 |  |  | abc | 122986.64 | 2010-03-10 00:00:00 | 667 | -3.492459654808044e-10 | 1107.98 |  |  | All you need is to learn how to do Advanced Filters.
 |  |  |  |  |  |  |  |  |  |  | If you wanted to automate this to do faster, you could clear
 |  |  |  |  |  |  |  |  |  |  | the range of S3:X400 before doing the advanced filter.
 |  |  | mno | 43946.97 | 2010-04-07 00:00:00 | 676 | -1.164153218269348e-10 | 443.91
 |  |  |  |  |  |  |  |  |  |  | I hope this helps..
 |  |  | ghi | 107195.04 | 2010-06-07 00:00:00 | 686 | 4.365574568510056e-11
 |  |  | mno | 15016.32 | 2010-06-02 00:00:00 | 685 | 0 | 151.68
 |  |  | abc | 57672.22 | 2010-07-22 00:00:00 | 694 | -1.891748979687691e-10 | 662.42
 |  |  |  |  |  |  |  |  | i can do the
Target list |  |  |  |  |  |  |  |  | =SUMIF(D4:D37, "abc", I4:I37)'
 |  |  |  |  |  |  |  |  | but need to list the items that
Name | Amt | INV. | Diff.
abc | 68136.2 | 656 | 614
abc | 77515.19 | 660 | 698.31
abc | 122986.64 | 667 | 1107.98
abc | 57672.22 | 694 | 662.42
selective data is copied to the target list if there is a number in
the Diff. column of the source list, AND the customer is abc.
A simple formula is desirable. If listing only selected parts makes
it too complicated, the whole range can be copied and the unneeded
portions manually deleted.