请写公式得到一些人的销售(注:公式应填写空白网格)。
B C D
2 Sales Rep Years Sales
3 Benson 2 120,000
4 Davidson 1 210,921
5 Ellison 1 310,983
6 Gomez 2 87,401
7 Hernandez 6 359,832
8 Kelly 3 120,000
9 Martin 2 502,983
10 Oswald 3 210,921
11 Reginald 1 310,983
12 Veras 4 359,832
13 Wilmington 4 502,983
Sales Rep Sales(Please write formulas in the next cells)
Ellison
Martin
Benson
B C D
2 Sales Rep Years Sales
3 Benson 2 120,000
4 Davidson 1 210,921
5 Ellison 1 310,983
6 Gomez 2 87,401
7 Hernandez 6 359,832
8 Kelly 3 120,000
9 Martin 2 502,983
10 Oswald 3 210,921
11 Reginald 1 310,983
12 Veras 4 359,832
13 Wilmington 4 502,983
Sales Rep Sales(Please write formulas in the next cells)
Ellison
Martin
Benson
