copying multiple rows based on column criteria

Hello Excel Gurus,

I could use a little help with something. I have a bunch of rows with account data. Each of these rows have about 30 colums of customer data. One of the rows has total electricity usage for the customer. I need to copy over all of the customers data for ones that have over 50,000 KWH in one of the columes.

The catch is, some customers have more than one account, and I need those customers that use of over 50,000 KWH regardless of how many accounts they have. So, I would need something that checks to see if each customer (customers with more than one account are listed multiple times) has more than one account, then sums up the values in the KWH column and then copies over their information if the total is greater than 50,000 KWH.

Any clues?

First use an autofilter to create a unique list of customers, where every customer is listed only once. Then use a SumIF to find the total KWH for each customer. Lastly sort by the KWH to find all users with more than 50,000.