Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Simple sales spreadsheet?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use a simple two sheet workbook to monitor sales for the current month. I need a simple method that will allow my administrator to automate the process.

    On sheet one the salesman's name, the amount and the date are entered. The last column starts empty but once the order has been vetted the word "accepted" is entered.

    The second sheet simply shows the totals of the orders.

    a)Total of orders
    b)Total of orders pending
    c)Total of orders accepted

    a = b + c

    I do it this way as it encourages the team to check the orders thoroughly and highlights problem orders (incorrect parts etc)

    Is there any way of automating this so that when the word "accpeted" is added it alters the totals on sheet two accordingly?

    All help gratefully received.

    Dave

    [ This Message was edited by: daveray on 2002-03-04 14:02 ]

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 14:01, daveray wrote:
    I use a simple two sheet workbook to monitor sales for the current month. I need a simple method that will allow my administrator to automate the process.

    On sheet one the salesman's name, the amount and the date are entered. The last column starts empty but once the order has been vetted the word "accepted" is entered.

    The second sheet simply shows the totals of the orders.

    a)Total of orders
    b)Total of orders pending
    c)Total of orders accepted

    a = b + c

    I do it this way as it encourages the team to check the orders thoroughly and highlights problem orders (incorrect parts etc)

    Is there any way of automating this so that when the word "accpeted" is added it alters the totals on sheet two accordingly?

    All help gratefully received.

    Dave



    [ This Message was edited by: daveray on 2002-03-04 14:02 ]
    Play around with some sumif statements, such as
    =SUMIF(Sheet1!F1:F1000,"",Sheet1!C1:C1000)
    for pended orders
    =SUMIF(Sheet1!F1:F1000,"accepted",Sheet1!C1:C1000)
    for accepted orders
    and perhaps a simple
    =SUM(Sheet1!C1:C1000)
    for total orders.

    This assumes order totals in col C and accepted flag in column F. It also assumes if an order is not accepted it is pended.

    good luck

    [ This Message was edited by: IML on 2002-03-04 15:19 ]

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're still stuck and willing to send me a sample of the dat, I can take a look at it for you.

    PJ

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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