Charlie, summing the sales is easy. To figure 80% of their sales, just multiply that number by 0.80. What do you mean by displaying "itemized sales per each customer with bill"? If you're trying to do this in Excel, I would really, REALLY, suggest you try a database like Access for this. Instead, we'll have to come up with a crazy filtering solution - or mail merge the data into Word.