I have sales data that is downloaded from our accounting system on a daily
basis which includes two seperate fields for salesman ie: sales1 & sales2.
This data has a summery at the change of each sales1 (using the
=SUBTOTAL(3,range) function) but I am manually adjusting the count for the
half counts ie: sales1 has data value would be .5 if sales2 is not empty. In
addition the value for sales2 needs to be added to the total summery of
sales1 by the value of sales1. An example of this would be Tom sold 4 units
3 of these units Tom is the only sales1 of the units Dick was a salesman as
well (sales2). Dick sold 5 units and is the only sales1 in all 5. My
summary report should show Tom with 3.5 units and Dick with 5.5

Any input would be greatly appricated.