Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching data/columns from two seperate files | Excel Discussion (Misc queries) | |||
Seperate the data in two columns | Excel Discussion (Misc queries) | |||
Seperate Data in one column into two columns? | Excel Worksheet Functions | |||
Import data into seperate columns | Excel Discussion (Misc queries) | |||
How do I seperate data in one column into multi columns | Excel Worksheet Functions |