Need help in excel

I have a spreadsheet (Excel 2003) with well over 40,000 records, and I'm
trying to filter it so that only records with specific information are
left. After doing this, I want to subtotal all records with identical
information in a specific field.

Here's the basic layout of my spreadsheet:

Code:

---

Customer        Produce      Amount
Jim Smith      apples          20
Jim Smith      grapes          100
Jim Smith      oranges        50
Jim Smith      bananas        10
Jim Smith      cherries        75
Jim Smith
Jim Smith
Jan Jones      apples          50
Jan Jones      strawberries    80
Jan Jones      pears          50
Jan Jones      bananas        30
Jan Jones
Bob Doe        apples          100
Bob Doe        oranges        50

---

For this example, I want to remove all records with blank fields in the
Produce column. Then, I only want to keep records with certain names in
the Produce column (apples, oranges, and pears). Finally, I want to
subtotal the Amount column while the field in the Customer column is the
same (subtotal the amounts for Jim Smith).

I really appreciate your help.

Hi

For this I would recommend using autofilter instead of writing a macro...

It shouldn't take more than 1-2 minutes.

Autofilter, produce column - custom - does equal "" - delete the rows
then use autofilter - custom - equals the products you want to keep
for subtotaling, use the subtotal worksheet function.

/Nick