Help with sum by criteria

[nublet]

Hi,

I need help with trying to write a sub that finds the total amount spent by each customer on the list (some customers bought more than once, so they have multiple entries in the list) and report those whose total is more than $2000 onto another worksheet (Report Worksheet). As part of my sub, I need to sort the list on the Report Worksheet in descending order.

The excel is attached.


Thank you very much!

[p24leclerc]

You should look at Pivot table. No programming. It is very flexible and your data are right for this tool.