count data from 2 seperate columns
 

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.

count data from 2 seperate columns
 

You may want to explain that with a data example, laid out in
grid/spreadsheet form, it got a bit confusing.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Winston Harrell" <Winston wrote in
message ...
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.

count data from 2 seperate columns
 

Thank you for your reply. Here is a sample of the sheet

Ctrl# sales1 sales2
37208 ROLDAN RAMIREZ
37236 ROLDAN
43500 ROLDAN
43570 ROLDAN
43384 ROLDAN
43595 ROLDAN NICHOLS
43679 ROLDAN
43472 ROLDAN
43583 ROLDAN
43499 ROLDAN
43597 ROLDAN STEVENS
43616 ROLDAN RAMIREZ
ROLDAN Count 12

The count for Roldan should be 10 as he had 4 sales where he only gets half
credit because there is a sales2.

Ctrl# sales1 sales2
43591 STEVENS
37227 STEVENS
STEVENS Count 2

The count for Stevens should be 2.5 because he had a half credit from one of
Roldans sales and no sales2 data.

I know this seems a bit confusing, but thats they way the boss wants it
counted.

Thanks,
Winston


"Bob Phillips" wrote:

You may want to explain that with a data example, laid out in
grid/spreadsheet form, it got a bit confusing.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Winston Harrell" <Winston wrote in
message ...
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.