+ Reply to Thread
Results 1 to 2 of 2

New Customer Count and Sum??

  1. #1
    Registered User
    Join Date
    07-07-2009
    Location
    Irvine, ca
    MS-Off Ver
    Excel 2003
    Posts
    1

    New Customer Count and Sum??

    HI there. attached is an example file. I tally up sales by quarter, by customer...very straight forward. However, when I wan to find out the NEW Customer business and NEW customer accounts, it gets complicated b/c i have customers that are re-ordering and those re-orders don't constitute a new customer anymore or new sales. I typically do this by counting long way with a lot of sorting and visual looks. How can i speed this up without using VBA, I'm not good at VBA. Customer column = A, fiscal quarters Sales run from B:Q, grand total = R. Much appreciated. Kb

    Account 2013-Q2 2013-Q3 2013-Q4 2014-Q1 2014-Q2 2014-Q3 2014-Q4 2015-Q1 2015-Q2 2015-Q3 2015-Q4 2016-Q1 2016-Q2 2016-Q3 2016-Q4 2017-Q1 Grand Total
    HSBC $493 $560 $1,053
    PepsiCo $154 $250 $559 $963
    Google $532 $378 $910
    Kellogg Company $350 $533 $883
    BMW $347 $501 $848
    Honda Motor Company, Ltd $275 $515 $790
    Porsche $125 $595 $720
    Louis Vuitton $225 $457 $682
    eBay $528 $123 $651
    Pizza Hut $311 $315 $626
    Credit Suisse $586 $586
    Yahoo! $585 $585
    Jack Daniel's $581 $581
    Starbucks $558 $558

    Count of new customer in period
    Sum total of new business in Period

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: New Customer Count and Sum??

    No file attached

    To attach a Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how to get the count of each customer in another sheet or as summary
    By santbiju in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-05-2016, 06:41 AM
  2. Count number of days between customer visits
    By amy22x3 in forum Excel General
    Replies: 5
    Last Post: 08-16-2016, 12:02 PM
  3. Count if's to determine the tagging of customer
    By geliedee in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-09-2016, 05:44 AM
  4. [SOLVED] Count if customer appear more than three time in a list
    By SwissExcel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2015, 12:44 PM
  5. Replies: 20
    Last Post: 11-10-2015, 09:48 AM
  6. [SOLVED] Formula to Count Unique Customer by Month
    By byankton in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-19-2013, 12:39 AM
  7. Count Duplicates Order numbers for one Customer
    By johncassell in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-12-2006, 07:39 PM

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