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?