Q: Track commission based upon number of sales
I received a new job (yay!) and I'm trying to track my commissions. I get paid by a combination of production and the number of sales I produce. Here's a little table to show what I mean.
# of sales | Payout Rate |
1 | 6% |
2 | 7% |
3 | 8% |
4 | 9% |
5 | 10% |
6 | 11% |
7 | 12% |
8 | 13% |
Let's say each sale the client pays $2,000 to keep it simple. The first sale I would earn $120, the second sale I would now earn $140 for each because it's retroactive (does this make sense?) with no cap. How would I effectively track this in numbers? Thanks in advance!
MacBook Pro, iOS 10
Posted on Sep 15, 2016 12:21 PM
This may work for you:
the first row of both tables is a header row
the last 4 rows of the "sales" table on the right are footer rows
B8 (the first footer row) contains the formula:
=SUM(B)
shorthand is
B8=SUM(B)
B9=MIN(COUNTA(A), COUNTA(B))
B10=VLOOKUP(B9,Sales bonus::A:B, 2, 0)
B11=B8×B10
Posted on Sep 15, 2016 2:09 PM




