IF example

Sales Person Week 1 Week 2 Week 3 Week 4 Totals

Patrick Marleau $ 9,550 $ 9,230 $ 8,500 $ 8,965 $ 36,245
Joe Thornton $ 8,000 $ 8,000 $ 8,500 $ 8,000 $ 32,500
Brent Burns $ 7,425 $ 8,580 $ 9,910 $ 7,512 $ 33,427
Joe Pavelski $ 9,560 $ 10,150 $ 10,200 $ 9,795 $ 39,705
Martin Jones $ 7,892 $ 7,695 $ 9,520 $ 10,252 $ 35,359
Weekly Totals $ 42,427 $ 43,655 $ 46,630 $ 44,524 $ 177,236

COUNTIF Count of people who met the target: 3

Arguments
countif(range to look for, condition)

Merge function
Wrap function
Border
Allingment of words
rename sheet
move sheet
delete sheet
hide and unhide rows and columns
resize
Goal: $ 34,000.00

Was Goal Achived? IF Arguments Min Max

Goal Achieved Goal is Achieved IF(condition, true, false) $ 8,500 $ 9,550
No Not $ 8,000 $ 8,500
No Not $ 7,425 $ 9,910
Goal Achieved Goal is Achieved $ 9,560 $ 10,200
Goal Achieved Goal is Achieved $ 7,695 $ 10,252
If minimum of weekly sales is greater than equal to
8000 and Goal is "Achived" then bouns else no bonus
And OR
Bouns/No Bonus Bouns/No Bonus
Bonus Bonus
No bonus Bonus
No bonus No Bonus
Bonus Bonus
No bonus Bonus
SUMIF Arguments
SUMIF(range to look for, what we searching for, range where to sum from)

Month Store # SKU Sales Units Store #

JAN 1000 E0028M $ 9,660 345 135000 3000
JAN 1050 E0028M $ 5,936 212 SKU #
JAN 2000 E0028M $ 10,136 362 E0032M
JAN 2050 E0028M $ 3,388 121
JAN 3000 E0028M $ 14,056 502
JAN 3050 E0028M $ 10,136 362
JAN 1000 E0030M $ 14,588 521
JAN 1050 E0030M $ 6,552 234
JAN 2000 E0030M $ 11,788 421
JAN 2050 E0030M $ 9,072 324
JAN 3000 E0030M $ 3,388 121
JAN 3050 E0030M $ 15,176 542
JAN 1000 E0032M $ 5,964 213
JAN 1050 E0032M $ 6,748 241
JAN 2000 E0032M $ 11,508 411
JAN 2050 E0032M $ 3,416 122
JAN 3000 E0032M $ 14,588 521
JAN 3050 E0032M $ 17,640 630
JAN 1000 E0034M $ 9,856 352
JAN 1050 E0034M $ 9,016 322
JAN 2000 E0034M $ 17,976 642
JAN 2050 E0034M $ 14,616 522
JAN 3000 E0034M $ 3,724 133
JAN 3050 E0034M $ 12,712 454
JAN 1000 E0036M $ 16,828 601
JAN 1050 E0036M $ 14,056 502
JAN 2000 E0036M $ 8,456 302
JAN 2050 E0036M $ 17,808 636
JAN 3000 E0036M $ 3,416 122
JAN 3050 E0036M $ 13,020 465
FEB 1000 E0028M $ 17,780 635
FEB 1050 E0028M $ 7,140 255
FEB 2000 E0028M $ 7,448 266
FEB 2050 E0028M $ 6,608 236
FEB 3000 E0028M $ 9,856 352
FEB 3050 E0028M $ 10,248 366
FEB 1000 E0030M $ 14,616 522
FEB 1050 E0030M $ 11,816 422
FEB 2000 E0030M $ 14,896 532
FEB 2050 E0030M $ 3,724 133
FEB 3000 E0030M $ 14,616 522
FEB 3050 E0030M $ 9,016 322
FEB 1000 E0032M $ 11,928 426
FEB 1050 E0032M $ 11,480 410
FEB 2000 E0032M $ 8,960 320
FEB 2050 E0032M $ 18,284 653
FEB 3000 E0032M $ 14,028 501
FEB 3050 E0032M $ 11,256 402
FEB 1000 E0034M $ 11,760 420
FEB 1050 E0034M $ 10,080 360
FEB 2000 E0034M $ 11,760 420
FEB 2050 E0034M $ 8,484 303
FEB 3000 E0034M $ 16,856 602
FEB 3050 E0034M $ 14,560 520
FEB 1000 E0036M $ 8,456 302
FEB 1050 E0036M $ 5,684 203
FEB 2000 E0036M $ 5,740 205
FEB 2050 E0036M $ 11,228 401
FEB 3000 E0036M $ 17,360 620
FEB 3050 E0036M $ 6,524 233
MAR 1000 E0028M $ 7,084 253
MAR 1050 E0028M $ 16,828 601
MAR 2000 E0028M $ 12,096 432
MAR 2050 E0028M $ 14,616 522
MAR 3000 E0028M $ 3,724 133
MAR 3050 E0028M $ 14,616 522
MAR 1000 E0030M $ 9,016 322
MAR 1050 E0030M $ 11,928 426
MAR 2000 E0030M $ 11,480 410
MAR 2050 E0030M $ 8,960 320
MAR 3000 E0030M $ 18,284 653
MAR 3050 E0030M $ 14,028 501
MAR 1000 E0032M $ 11,256 402
MAR 1050 E0032M $ 11,760 420
MAR 2000 E0032M $ 10,080 360
MAR 2050 E0032M $ 11,760 420
MAR 3000 E0032M $ 8,484 303
MAR 3050 E0032M $ 16,856 602
MAR 1000 E0034M $ 14,560 520
MAR 1050 E0034M $ 8,456 302
MAR 2000 E0034M $ 5,684 203
MAR 2050 E0034M $ 5,740 205
MAR 3000 E0034M $ 5,936 212
MAR 3050 E0034M $ 10,136 362
MAR 1000 E0036M $ 3,388 121
MAR 1050 E0036M $ 14,056 502
MAR 2000 E0036M $ 10,136 362
MAR 2050 E0036M $ 14,588 521
MAR 3000 E0036M $ 6,552 234
MAR 3050 E0036M $ 11,788 421
JAN 1000 B0028M $ 9,072 324
JAN 1050 B0028M $ 3,388 121
JAN 2000 B0028M $ 15,176 542
JAN 2050 B0028M $ 5,964 213
JAN 3000 B0028M $ 3,724 133
JAN 3050 B0028M $ 14,616 522
JAN 1000 B0030M $ 9,016 322
JAN 1050 B0030M $ 11,928 426
JAN 2000 B0030M $ 11,480 410
JAN 2050 B0030M $ 8,960 320
JAN 3000 B0030M $ 18,284 653
JAN 3050 B0030M $ 14,028 501
JAN 1000 B0032M $ 11,256 402
JAN 1050 B0032M $ 11,760 420
JAN 2000 B0032M $ 10,080 360
JAN 2050 B0032M $ 11,760 420
JAN 3000 B0032M $ 8,484 303
JAN 3050 B0032M $ 16,856 602
JAN 1000 B0034M $ 14,560 520
JAN 1050 B0034M $ 8,456 302
JAN 2000 B0034M $ 5,684 203
JAN 2050 B0034M $ 5,740 205
JAN 3000 B0034M $ 5,936 212
JAN 3050 B0034M $ 10,136 362
JAN 1000 B0036M $ 3,388 121
JAN 1050 B0036M $ 14,056 502
JAN 2000 B0036M $ 10,136 362
JAN 2050 B0036M $ 14,588 521
JAN 3000 B0036M $ 6,552 234
JAN 3050 B0036M $ 11,788 421
FEB 1000 B0028M $ 9,072 324
FEB 1050 B0028M $ 3,388 121
FEB 2000 B0028M $ 15,176 542
FEB 2050 B0028M $ 5,964 213
FEB 3000 B0028M $ 14,588 521
FEB 3050 B0028M $ 17,640 630
FEB 1000 B0030M $ 9,856 352
FEB 1050 B0030M $ 9,016 322
FEB 2000 B0030M $ 17,976 642
FEB 2050 B0030M $ 14,616 522
FEB 3000 B0030M $ 3,724 133
FEB 3050 B0030M $ 12,712 454
FEB 1000 B0032M $ 16,828 601
FEB 1050 B0032M $ 14,056 502
FEB 2000 B0032M $ 8,456 302
FEB 2050 B0032M $ 17,808 636
FEB 3000 B0032M $ 3,416 122
FEB 3050 B0032M $ 13,020 465
FEB 1000 B0034M $ 17,780 635
FEB 1050 B0034M $ 7,140 255
FEB 2000 B0034M $ 7,448 266
FEB 2050 B0034M $ 6,608 236
FEB 3000 B0034M $ 9,856 352
FEB 3050 B0034M $ 10,248 366
FEB 1000 B0036M $ 14,616 522
FEB 1050 B0036M $ 11,816 422
FEB 2000 B0036M $ 14,896 532
FEB 2050 B0036M $ 3,724 133
FEB 3000 B0036M $ 14,616 522
FEB 3050 B0036M $ 9,016 322
MAR 1000 B0028M $ 5,936 212
MAR 1050 B0028M $ 10,136 362
MAR 2000 B0028M $ 3,388 121
MAR 2050 B0028M $ 14,056 502
MAR 3000 B0028M $ 10,136 362
MAR 3050 B0028M $ 14,588 521
MAR 1000 B0030M $ 6,552 234
MAR 1050 B0030M $ 11,788 421
MAR 2000 B0030M $ 9,072 324
MAR 2050 B0030M $ 3,388 121
MAR 3000 B0030M $ 15,176 542
MAR 3050 B0030M $ 5,964 213
MAR 1000 B0032M $ 14,588 521
MAR 1050 B0032M $ 17,640 630
MAR 2000 B0032M $ 9,856 352
MAR 2050 B0032M $ 9,016 322
MAR 3000 B0032M $ 17,976 642
MAR 3050 B0032M $ 14,616 522
MAR 1000 B0034M $ 3,724 133
MAR 1050 B0034M $ 12,712 454
MAR 2000 B0034M $ 16,828 601
MAR 2050 B0034M $ 14,056 502
MAR 3000 B0034M $ 8,456 302
MAR 3050 B0034M $ 17,808 636
MAR 1000 B0036M $ 3,416 122
MAR 1050 B0036M $ 13,020 465
MAR 2000 B0036M $ 17,780 635
MAR 2050 B0036M $ 7,140 255
MAR 3000 B0036M $ 7,448 266
MAR 3050 B0036M $ 6,608 236
JAN 1000 C0028M $ 9,856 352
JAN 1050 C0028M $ 10,248 366
JAN 2000 C0028M $ 14,616 522
JAN 2050 C0028M $ 11,816 422
JAN 3000 C0028M $ 14,896 532
JAN 3050 C0028M $ 3,724 133
JAN 1000 C0030M $ 14,616 522
JAN 1050 C0030M $ 9,016 322
JAN 2000 C0030M $ 3,724 133
JAN 2050 C0030M $ 14,616 522
JAN 3000 C0030M $ 9,016 322
JAN 3050 C0030M $ 11,928 426
JAN 1000 C0032M $ 11,480 410
JAN 1050 C0032M $ 8,960 320
JAN 2000 C0032M $ 18,284 653
JAN 2050 C0032M $ 14,028 501
JAN 3000 C0032M $ 11,256 402
JAN 3050 C0032M $ 11,760 420
JAN 1000 C0034M $ 10,080 360
JAN 1050 C0034M $ 11,760 420
JAN 2000 C0034M $ 8,484 303
JAN 2050 C0034M $ 16,856 602
JAN 3000 C0034M $ 14,560 520
JAN 3050 C0034M $ 8,456 302
JAN 1000 C0036M $ 5,684 203
JAN 1050 C0036M $ 14,588 521
JAN 2000 C0036M $ 17,640 630
JAN 2050 C0036M $ 9,856 352
JAN 3000 C0036M $ 9,016 322
JAN 3050 C0036M $ 17,976 642
FEB 1000 C0028M $ 14,616 522
FEB 1050 C0028M $ 3,724 133
FEB 2000 C0028M $ 12,712 454
FEB 2050 C0028M $ 16,828 601
FEB 3000 C0028M $ 14,056 502
FEB 3050 C0028M $ 8,456 302
FEB 1000 C0030M $ 17,808 636
FEB 1050 C0030M $ 3,416 122
FEB 2000 C0030M $ 13,020 465
FEB 2050 C0030M $ 17,780 635
FEB 3000 C0030M $ 7,140 255
FEB 3050 C0030M $ 7,448 266
FEB 1000 C0032M $ 6,608 236
FEB 1050 C0032M $ 9,856 352
FEB 2000 C0032M $ 10,248 366
FEB 2050 C0032M $ 14,616 522
FEB 3000 C0032M $ 11,816 422
FEB 3050 C0032M $ 14,896 532
FEB 1000 C0034M $ 3,724 133
FEB 1050 C0034M $ 14,616 522
FEB 2000 C0034M $ 9,016 322
FEB 2050 C0034M $ 5,936 212
FEB 3000 C0034M $ 10,136 362
FEB 3050 C0034M $ 3,388 121
FEB 1000 C0036M $ 14,056 502
FEB 1050 C0036M $ 10,136 362
FEB 2000 C0036M $ 14,588 521
FEB 2050 C0036M $ 6,552 234
FEB 3000 C0036M $ 11,788 421
FEB 3050 C0036M $ 9,072 324
MAR 1000 C0028M $ 3,388 121
MAR 1050 C0028M $ 15,176 542
MAR 2000 C0028M $ 5,964 213
MAR 2050 C0028M $ 3,724 133
MAR 3000 C0028M $ 14,616 522
MAR 3050 C0028M $ 9,016 322
MAR 1000 C0030M $ 11,928 426
MAR 1050 C0030M $ 11,480 410
MAR 2000 C0030M $ 8,960 320
MAR 2050 C0030M $ 18,284 653
MAR 3000 C0030M $ 14,028 501
MAR 3050 C0030M $ 11,256 402
MAR 1000 C0032M $ 11,760 420
MAR 1050 C0032M $ 10,080 360
MAR 2000 C0032M $ 11,760 420
MAR 2050 C0032M $ 8,484 303
MAR 3000 C0032M $ 16,856 602
MAR 3050 C0032M $ 14,560 520
MAR 1000 C0034M $ 8,456 302
MAR 1050 C0034M $ 5,684 203
MAR 2000 C0034M $ 5,740 205
MAR 2050 C0034M $ 3,724 133
MAR 3000 C0034M $ 14,616 522
MAR 3050 C0034M $ 9,016 322
MAR 1000 C0036M $ 11,928 426
MAR 1050 C0036M $ 11,480 410
MAR 2000 C0036M $ 8,960 320
MAR 2050 C0036M $ 18,284 653
MAR 3000 C0036M $ 14,028 501
MAR 3050 C0036M $ 11,256 402
2916172
 135000 3000

Total Units Total Sales

Total Units Total Sales

Functions to be used Full Name
Concatenate Smith Howard Howard Smith
Left Gonzales Joe Joe Gonzales
Right Scote Gail Gail Scote
len Kane Sheryl Sheryl Kane
search Hapsbuch Kendrick Kendrick Hapsbuch
Henders Mark Mark Henders
Atherton Katie Katie Atherton
Bellwood Frank Frank Bellwood
Cooper Linda Linda Cooper
Cronwith Brent Brent Cronwith
Simpson Sandrae Sandrae Simpson
search,left,length,concat Sindole Randy Randy Sindole
Smith Ellen Ellen Smith
Vuanuo Tuome Tuome Vuanuo
Szcznyck Tadeuz Tadeuz Szcznyck
Wu Tammy Tammy Wu
P Durgavihashini Durgavihashini P
 First name Last name Full Name
12 Howard Smith Howard Smith 6
12 Joe Gonzales JoeGonzales 3
10 Gail Scote GailScote 4
11 Sheryl Kane SherylKane 6
17 Kendrick Hapsbuch KendrickHapsbuch 8
12 Mark Henders MarkHenders 4
14 Katie Atherton KatieAtherton 5
14 Frank Bellwood FrankBellwood 5
12 Linda Cooper LindaCooper 5
14 Brent Cronwith BrentCronwith 5
15 Sandrae Simpson SandraeSimpson 7
13 Randy Sindole RandySindole 5
11 Ellen Smith EllenSmith 5
12 Tuome Vuanuo TuomeVuanuo 5
15 Tadeuz Szcznyck TadeuzSzcznyck 6
8 Tammy Wu TammyWu 5
16 Durgavihashini P DurgavihashiniP 14
First name Last name Full Name
#NAME? #NAME? Howard Smith
#NAME? #NAME? Joe Gonzales
#NAME? #NAME? Gail Scote
#NAME? #NAME? Sheryl Kane
#NAME? #NAME? Kendrick Hapsbuch
#NAME? #NAME? Mark Henders
#NAME? #NAME? Katie Atherton
#NAME? #NAME? Frank Bellwood
#NAME? #NAME? Linda Cooper
#NAME? #NAME? Brent Cronwith
#NAME? #NAME? Sandrae Simpson
#NAME? #NAME? Randy Sindole
#NAME? #NAME? Ellen Smith
#NAME? #NAME? Tuome Vuanuo
#NAME? #NAME? Tadeuz Szcznyck
#NAME? #NAME? Tammy Wu
#NAME? #NAME? Durgavihashini P
#NAME? #NAME? Howard Smith
#NAME? #NAME? Joe Gonzales
#NAME? #NAME? Gail Scote
#NAME? #NAME? Sheryl Kane
#NAME? #NAME? Kendrick Hapsbuch
#NAME? #NAME? Mark Henders
#NAME? #NAME? Katie Atherton
#NAME? #NAME? Frank Bellwood
#NAME? #NAME? Linda Cooper
#NAME? #NAME? Brent Cronwith
#NAME? #NAME? Sandrae Simpson
#NAME? #NAME? Randy Sindole
#NAME? #NAME? Ellen Smith
#NAME? #NAME? Tuome Vuanuo
#NAME? #NAME? Tadeuz Szcznyck
#NAME? #NAME? Tammy Wu
#NAME? #NAME? Durgavihashini P