Thread
:
count data from 2 seperate columns
View Single Post
#
2
Posted to microsoft.public.excel.programming
Bob Phillips[_6_]
external usenet poster
Posts: 11,272
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.
Reply With Quote
Bob Phillips[_6_]
View Public Profile
Find all posts by Bob Phillips[_6_]