+ Reply to Thread
Results 1 to 2 of 2

Google Sheets - line up orders by turnover or quantity

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Prague
    MS-Off Ver
    2018
    Posts
    1

    Google Sheets - line up orders by turnover or quantity

    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.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,048

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

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1