Hello,
I am trying to provide commissions statements to my sales people. My sales report lists all levels for each account: Salesperson, Sales Manager, and Director. In some cases, the employee ID in all three columns is the same person (the department director manages a few highly important accounts.) I am trying to sum the total sales for each person without double or triple counting any rows. I'm having trouble returning the sales for all accounts of a director using sumifs. In this example, Employee 1 and 2 exist in multiple columns, but I only want to count each account once. Each period, there are multiple changes and managers and directors fill in at different levels based on leaves, personnel changes, etc. I also don't want to ever miss some sales when an employee gets a promotion. How can I sumifs the sales column if the Employee's ID exists in ANY of the 3 columns?
<tbody>
</tbody>
I am trying to provide commissions statements to my sales people. My sales report lists all levels for each account: Salesperson, Sales Manager, and Director. In some cases, the employee ID in all three columns is the same person (the department director manages a few highly important accounts.) I am trying to sum the total sales for each person without double or triple counting any rows. I'm having trouble returning the sales for all accounts of a director using sumifs. In this example, Employee 1 and 2 exist in multiple columns, but I only want to count each account once. Each period, there are multiple changes and managers and directors fill in at different levels based on leaves, personnel changes, etc. I also don't want to ever miss some sales when an employee gets a promotion. How can I sumifs the sales column if the Employee's ID exists in ANY of the 3 columns?
Director | Manager | Salesperson | Account | Sales |
Employee 1 | Employee 1 | Employee 1 | ABC Company | 500 |
Employee 1 | Employee 1 | Employee 2 | DEF Company | 600 |
Employee 1 | Employee 2 | Employee 2 | GHI Company | 200 |
Employee 1 | Employee 2 | Employee 3 | XYZ Company | 900 |
<tbody>
</tbody>