I am a intermediate user of Excel and am in the process of learning more. I have a spreadsheet of sales data. Our sales is very easy. If the sales person works alone the get 100% of the deal, or 1 count. If two people work on a sales deal together they share the deal 50/50, or .5. I have two columns of sales people.
<colgroup><col><col></colgroup><tbody>
</tbody>
In this example:
Garrett - .5
Amy - .5
Radlick - .5+.5=1
Chance - 2
Ray - 1
Slaymaker - 2
Richard - 1
I am working with Pivot Tables ( if another way is easier, im all ears), how do i count the setup the PT to count the number of deals per Sales Person correctly?
SALES PERSON 1 | SALES PERSON 2 |
GARRETT | BRANDON |
AMY | RAY |
RADLICK | AMANDA |
CHANCE | |
RAY | RYAN |
SLAYMAKER | |
RICHARD | |
TELL | RADLICK |
JAMIE | MAX |
SLAYMAKER | |
HARLIE | |
CHANCE |
<colgroup><col><col></colgroup><tbody>
</tbody>
In this example:
Garrett - .5
Amy - .5
Radlick - .5+.5=1
Chance - 2
Ray - 1
Slaymaker - 2
Richard - 1
I am working with Pivot Tables ( if another way is easier, im all ears), how do i count the setup the PT to count the number of deals per Sales Person correctly?