Simple sales spreadsheet?

daveray

New Member
Joined
Mar 3, 2002
Messages
28
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,288
Members
448,563
Latest member
MushtaqAli

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top