we sell products that sometimes get "split" between 2 salespeople. I have set
up a basic spreadsheet that tracks sales and profit but can't figure out how
to account for "half deals" Any help would be appreciated and I can supply a
sample of the sheet if necessary.

"Myles B" wrote in message
...
we sell products that sometimes get "split" between 2 salespeople. I have
set
up a basic spreadsheet that tracks sales and profit but can't figure out
how
to account for "half deals" Any help would be appreciated and I can
supply a
sample of the sheet if necessary.


Depends how you are "tracking" sales and profit.

In colums like this:
Date Customer Stk # Front End Holdback Total Gross M.T.D.
Total Average Salesperson #1 Salesperson #2
6/1/2009 JONES M9156 $10.00 $10.00 $20.00 $20.00 $170.08 SEBAS CHASE
6/1/2009 SMITH T9205 $200.00 $10.00 $210.00 $230.00 $170.08 CHASE BARB
6/2/2009 BAUER S9100 $100.00 $10.00 $110.00 $340.00 $170.08 BARB


"Gordon" wrote:


"Myles B" wrote in message
...
we sell products that sometimes get "split" between 2 salespeople. I have
set
up a basic spreadsheet that tracks sales and profit but can't figure out
how
to account for "half deals" Any help would be appreciated and I can
supply a
sample of the sheet if necessary.


Depends how you are "tracking" sales and profit.

"Myles B" wrote in message
...
In colums like this:
Date Customer Stk # Front End Holdback Total Gross M.T.D.
Total Average Salesperson #1 Salesperson #2
6/1/2009 JONES M9156 $10.00 $10.00 $20.00 $20.00 $170.08 SEBAS CHASE
6/1/2009 SMITH T9205 $200.00 $10.00 $210.00 $230.00 $170.08 CHASE BARB
6/2/2009 BAUER S9100 $100.00 $10.00 $110.00 $340.00 $170.08 BARB



So how is the Average per Salesperson calculated in the first place?

I'm not concerned about the averages. There is another page that shows total
sales for the month at a glance and I need to be able to show "half deals"
(sales split between salesperson 1 and 2)

"Gordon" wrote:


"Myles B" wrote in message
...
In colums like this:
Date Customer Stk # Front End Holdback Total Gross M.T.D.
Total Average Salesperson #1 Salesperson #2
6/1/2009 JONES M9156 $10.00 $10.00 $20.00 $20.00 $170.08 SEBAS CHASE
6/1/2009 SMITH T9205 $200.00 $10.00 $210.00 $230.00 $170.08 CHASE BARB
6/2/2009 BAUER S9100 $100.00 $10.00 $110.00 $340.00 $170.08 BARB



So how is the Average per Salesperson calculated in the first place?

"Myles B" wrote in message
...
I'm not concerned about the averages. There is another page that shows
total
sales for the month at a glance and I need to be able to show "half deals"
(sales split between salesperson 1 and 2)

I'm now confused. Are you asking how physically, do you split a two-salesman
sale between the two salesmen?