Simple sales spreadsheet?

[daveray]

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

 

[IML]

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

 

[Paul-Johnson]

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