Google Sheets - line up orders by turnover or quantity

**Ymmies** · 01-08-2019, 10:54 AM

Hi guys,

maybe you could help me with this.

I have an automatically updated Google Sheets table with all the information about my customers. Basically the columns are:

A - Unique order ID
B - Date of the order
C - Date of the payment
E - Name of the customer
F - Business ID of the customer
H - Total price of the order

I would like to line up the customers (to another sheet maybe) based on:

a) the number of their orders
b) the total turnover

So ideally i would clearly see who paid me the most money and who made the most orders and I could put that in a chart.
I was able to list all the customers in a certain date range (thanks to the query function). But I am having a hard time figuring out how to achieve this.

Any help would be appreciated.

Thank you.

**JeteMc** · 01-18-2019, 08:28 AM

Hello Ymmies and Welcome to Excel Forum.
Note that the following is not tested however it appears that Google Sheets has Countifs and Sumifs functions.
I believe that since you have a list of customers on another sheet (Sheet2) you could count the number of orders using Countifs as in:
B2: =COUNTIFS(Sheet1!E:E,A2)
Note that the above assumes the names of the customers on Sheet2 are in column A.
I believe that you could sum the price of the orders using Sumifs as in:
C2: =SUMIFS(Sheet1!H:H,Sheet1!E:E,A2)
If this doesn't work I would suggest uploading a sample Excel workbook, mimicking your Google sheets workbook, with your expected results manually entered, so that we can attempt to match the results using formulas/code.
To upload an Excel workbook click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

Google Sheets - line up orders by turnover or quantity

LinkBack

Thread Tools

Rate This Thread

Display

Google Sheets - line up orders by turnover or quantity

Re: Google Sheets - line up orders by turnover or quantity

Thread Information

Users Browsing this Thread

Similar Threads

Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets

please check quantity on each line

Attached Photo and create line orders in excel

google sheets copy and repeat line

email row contents based on cell values (google sheets populated by google forms)

Calculate orders that went out same day from multiple sheets

is there any limitation to the quantity of line groups?

Bookmarks

Bookmarks

Posting Permissions