Monday, July 28, 2014

yogi_From Table Of Sales Data For SalesPersons Count Number Of Sales By SalesPerson

                           Google Spreadsheet   Post  #1712
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul-28-2014
post by Lance Williams:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/flSMy5GSxQo)
Counting
How can I count the number of sales by salesperson?  If there is a salesperson initials in Column B (SP1) and blank in Column C (SP2) then count a full unit (+1).  If there is a salesperson in both columns then it is a half (+.5) unit for each sales person...as follows:

CustomerSP1SP2
SmithRH
JonesNSRH
WilliamsDT
PerryAO
ThompsonNSRH
DriskillNSDT
Results
RH2
NS1.5
DT1.5
AO1

I already have the salespeople listed in alphabetical order with other information so I do not want to Transpose.  Thank you.
------------------------------------------------------------------------------------------------------------------------------------------