I am trying to find out the top 3 customers from a list. I want to do this based on the number of orders.

At the end I would like to be able to display the following values:

My output table is like the following just with way more clients

CodePudding user response：

You may use below formula.

=QUERY(A1:C,"select A, count(A), sum(C) 
where A is not null 
group by A 
order by count(A) DESC 
limit 3")

CodePudding user response：

Try following query

Select Client,Count(Client) 'Amount of Orders',Sum(Amount) 'Summed Amount of 
Ordervalue' From OrderDetails Group By Client