+ Reply to Thread
Results 1 to 3 of 3

Calculate # of sales per week, month & quarter

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2011
    Posts
    1

    Calculate # of sales per week, month & quarter

    Hello,
    Great forum! First time poster and in need of some help. Any help will be greatly appreciated .
    I am trying to create a spreadsheet that will give me an idea of staff performance at various store locations (to be used for commission purposes).
    Data will include date, staff ID, store, and whether a particular sale was made.
    I would like to calculate the number of sales performed that week, month, and quarter and if possible separate the information based on the particular staff involved (using staff ID).
    I have no idea how to set any of this up.
    Can anyone please help me out?
    Thank you!

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Calculate # of sales per week, month & quarter

    give us the input itemized columns in a excel format and we'll go from there

  3. #3
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Calculate # of sales per week, month & quarter

    If seems from a high level that if put column headers with your date, staff id, store and sales data and then enter the data....which will be time consuming.... you can use a pivot table to do everything you are trying to do....in a PT you can group by dates(days, weeks, months, quarters, years)...rows = staff id, columns= date and values = sum of sales....then pivot til your hearts content....HTH...

    Ernest

+ 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