[go: up one dir, main page]
Scribd
Upload
30 views1 page

Formula Excel Sheet

In December 2015, the sales team's monthly goal was 34,000. H. James, K. Dunn, R. Smith, and D. O'Brian met their goals as their totals exceeded 34,000 and their minimum weekly sales were over 8,000. L. Carrie did not meet the goal. In total, 4 out of the 5 sales people reached their monthly sales targets.

Uploaded by

Abhi Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
30 views1 page

Formula Excel Sheet

In December 2015, the sales team's monthly goal was 34,000. H. James, K. Dunn, R. Smith, and D. O'Brian met their goals as their totals exceeded 34,000 and their minimum weekly sales were over 8,000. L. Carrie did not meet the goal. In total, 4 out of the 5 sales people reached their monthly sales targets.

Uploaded by

Abhi Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Sales Figures - December 2015 Monthly Goal: 34000

Sales Person Week 1 Week 2 Week 3 Week 4 Totals Was Goal Met? Bonus Status
H. James 9550 9230 8500 8965 =SUM(B5:E5) =IF(F5>=$I$2,"YES", "NO") =IF(AND(H5="YES", MIN(B5:E5)>=8000
K. Dunn 5975 6900 8500 10100 =SUM(B6:E6) =IF(F6>=$I$2,"YES", "NO") =IF(AND(H6="YES", MIN(B6:E6)>=8000
L. Carrie 7425 8580 9910 7512 =SUM(B7:E7) =IF(F7>=$I$2,"YES", "NO") =IF(AND(H7="YES", MIN(B7:E7)>=8000
R. Smith 9560 10150 10200 9795 =SUM(B8:E8) =IF(F8>=$I$2,"YES", "NO") =IF(AND(H8="YES", MIN(B8:E8)>=8000
D. O'Brian 7892 7695 9520 10252 =SUM(B9:E9) =IF(F9>=$I$2,"YES", "NO") =IF(AND(H9="YES", MIN(B9:E9)>=8000
Weekly Total =SUM(B5:B9) =SUM(C5:C9) =SUM(D5:D9) =SUM(E5:E9) =SUM(F5:F9)

Total Sales: =SUM(F5:F10)


Current number of sales people who haved reached their goal: =COUNTIF(H5:H9, "YES")

You might also like