# Display cell reference based on the data in a cell that is part of a sum record

#### drozeveld

##### New Member
I used Excel to figure the payroll commission that we pay our salespeople.

I have an individual worksheet for each person that totals in the same manner for everyone.

At the end, I have a page that totals all of the individual totals.

We use a "draw system" for paying our employees, which means that if they don't make a certain amount for this payroll period, we still pay them a base amount, but then they owe us back the difference on their next pay.

So, on each individual worksheet, there is a calculation for what the salespersons draw balance is, and like explained above, there is a total for this cell on the "totals" page.

I would like it to list somewhere on the totals page, which worksheets (or salespeople) have a draw balance of greater than \$0.00.

For an (small) example:

Draw balance
Salesperson (worksheet) A \$0.00
Salesperson (worksheet) B \$ 5.00
Salesperson (worksheet) C \$20.00

Totals worksheet draw balance = \$25.00

On the totals page I would like to see:

Salespersons (worksheets) that have a draw balance of greater than \$0.00
B \$ 5.00
C \$20.00

Hope I've explained this well enough.

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

Replies
4
Views
79
Replies
0
Views
73
Replies
0
Views
401
Replies
3
Views
263
Replies
1
Views
292

1,141,282
Messages
5,705,483
Members
421,398
Latest member
Rahat Anwar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back