Name Joining Date Email Department Salary
Mark 12/31/2021 mark@gmail.com Human Resources 50000
Brian 12/31/2021 brian@gmail.com Sales 45000
Alan 1/14/2022 alan@gmail.com Legal 25000
Ton 1/14/2022 ton@gmail.com Retail 25000
Agatha 2/1/2022 agatha@gmail.com Sales 32000
Lana 2/1/2022 lana@gmail.com Accounting 45000
Heather 8/4/2022 heather@gmail.com Accounting 50000
Ben 1/3/1900 ben@gmail.com Sales 30000
Caitlyn 1/3/1900 caitlyn@gmail.com Retail 34000
Gibbs 3/1/2022 gibbs@gmail.com Retail 25000
Anderson 3/1/2022 anderson@gmail.com Sales 24000
Michael 3/1/2022 michael@gmail.com Retail 100000
David 3/1/2022 david@gmail.com Sales 5000
Jacob 3/1/2022 jacob@gmail.com Support 36000
John 3/15/2022 john@gmail.com Business Development 42000
Leonardo 3/15/2022 leonardo@gmail.com Business Development 65000
Matthew 4/1/2022 matthew@gmail.com Human Resources 35000
Joana 6/1/2022 joana@gmail.com Business Development 78000
Ross 7/2/2022 ross@gmail.com Legal 23000
Joey 7/15/2022 joey@gmail.com Business Development 56000
Jack 1/3/2022 jack@gmail.com Support 45000
IF (Function) Count IF Sum_if Average Averageif
Average Performer Human Resources 2 85000 41428.571429 42500
Average Performer Sales 5 136000 27200
Average Performer Legal 2 48000 24000
Average Performer Retail 4 184000 46000
Average Performer Accounting 2 95000 47500
Average Performer Business Development 4 241000 60250
Average Performer Support 2 81000 40500
Average Performer
Average Performer
Average Performer
Average Performer
High Performer
Average Performer
Average Performer
Average Performer
High Performer
Average Performer
High Performer
Average Performer
High Performer
Average Performer
Concat
Mark -- Human Resources
Brian -- Sales
Alan -- Legal
Ton -- Retail
Agatha -- Sales
Lana -- Accounting
Heather -- Accounting
Ben -- Sales
Caitlyn -- Retail
Gibbs -- Retail
Anderson -- Sales
Michael -- Retail
David -- Sales
Jacob -- Support
John -- Business Development
Leonardo -- Business Development
Matthew -- Human Resources
Joana -- Business Development
Ross -- Legal
Joey -- Business Development
Jack -- Support
Name Joining Date Email Department Salary Score
David 3/1/2022 david@gmail.com Sales 5000 28
Ross 7/2/2022 ross@gmail.com Legal 23000 71
Anderson 3/1/2022 anderson@gmail.com Sales 24000 50
Alan 1/14/2022 alan@gmail.com Legal 25000 35
Ton 1/14/2022 ton@gmail.com Retail 25000 81
Gibbs 3/1/2022 gibbs@gmail.com Retail 25000 46
Ben 1/3/1900 ben@gmail.com Sales 30000 43
Agatha 2/1/2022 agatha@gmail.com Sales 32000 85
Caitlyn 1/3/1900 caitlyn@gmail.com Retail 34000 94
Matthew 4/1/2022 matthew@gmail.com Human Resources 35000 63
Jacob 3/1/2022 jacob@gmail.com Support 36000 92
John 3/15/2022 john@gmail.com Business Development 42000 69
Brian 12/31/2021 brian@gmail.com Sales 45000 50
Lana 2/1/2022 lana@gmail.com Accounting 45000 53
Jack 1/3/2022 jack@gmail.com Support 45000 27
Mark 12/31/2021 mark@gmail.com Human Resources 50000 40
Heather 8/4/2022 heather@gmail.com Accounting 50000 49
Joey 7/15/2022 joey@gmail.com Business Development 56000 55
Leonardo 3/15/2022 leonardo@gmail.com Business Development 65000 23
Joana 6/1/2022 joana@gmail.com Business Development 78000 83
Michael 3/1/2022 michael@gmail.com Retail 100000 24
Index Match Unique IFS COUNTIFS
Want to Improve Human Resources >=50000 1
A Sales >=50000 0
A Legal >=50000 0
30000 12 A Retail >=50000 1
A Accounting >=50000 1
Want to Improve Business Development >=50000 3
alan@gmail.com A Support >=50000 0
A
A
A
A
A
A
A
Want to Improve
A
A
A
Want to Improve
B
A
SUMIFS AVERAGEIFS
85000 42500
131000 32750
25000 25000
184000 46000
95000 47500
241000 60250
81000 40500
Name Joining Date Email Department Salary
David 3/1/2022 david@gmail.com Sales Hunderd
Ross 7/2/2022 ross@gmail.com Legal Thousand
Anderson 3/1/2022 anderson@gmail.com Sales 24000
Alan 1/14/2022 alan@gmail.com Legal Lakhs
Ton 1/14/2022 ton@gmail.com Retail 25000
Gibbs 3/1/2022 gibbs@gmail.com Retail 25000
Ben 1/3/1900 ben@gmail.com Sales 30000
Agatha 2/1/2022 agatha@gmail.com Sales 32000
Caitlyn 1/3/1900 caitlyn@gmail.com Retail 34000
Matthew 4/1/2022 matthew@gmail.com Human Resources 35000
Jacob 3/1/2022 jacob@gmail.com Support 36000
John 3/15/2022 john@gmail.com Business Development 42000
Brian 12/31/2021 brian@gmail.com Sales 45000
Lana 2/1/2022 lana@gmail.com Accounting 45000
Jack 1/3/2022 jack@gmail.com Support 45000
Mark 12/31/2021 mark@gmail.com Human Resources 50000
Heather 8/4/2022 heather@gmail.com Accounting 50000
Joey 7/15/2022 joey@gmail.com Business Development 56000
Leonardo 3/15/2022 leonardo@gmail.com Business Development 65000
Joana 6/1/2022 joana@gmail.com Business Development 78000
Michael 3/1/2022 michael@gmail.com Retail 100000
VLOOKUP
jacob@gmail.com
XLOOKUP
#NAME?
HLOOKUP
anderson@gmail.com
COUNT
18
COUNTA
21
Name Joining Date Email Department Salary LEFT
David 3/1/2022 david@gmail.com Sales Hunderd david@g
Ross 7/2/2022 ross@gmail.com Legal Thousand
Anderson 3/1/2022 anderson@gmail.com Sales 24000
Alan 1/14/2022 alan@gmail.com Legal Lakhs RIGHT
Ton 1/14/2022 ton@gmail.com Retail 25000 l.com
Gibbs 3/1/2022 gibbs@gmail.com Retail 25000
Ben 1/3/1900 ben@gmail.com Sales 30000
Agatha 2/1/2022 agatha@gmail.com Sales 32000 MID
Caitlyn 1/3/1900 caitlyn@gmail.com Retail 34000 itlyn@g
Matthew 4/1/2022 matthew@gmail.com Human Resources 35000
Jacob 3/1/2022 jacob@gmail.com Support 36000
John 3/15/2022 john@gmail.com Business Development 42000 LEN
Brian 12/31/2021 brian@gmail.com Sales 45000 15
Lana 2/1/2022 lana@gmail.com Accounting 45000
Jack 1/3/2022 jack@gmail.com Support 45000
Mark 12/31/2021 mark@gmail.com Human Resources 50000 SEARCH
Heather 8/4/2022 heather@gmail.com Accounting 50000 2
Joey 7/15/2022 joey@gmail.com Business Development 56000
Leonardo 3/15/2022 leonardo@gmail.com Business Development 65000
Joana 6/1/2022 joana@gmail.com Business Development 78000
Michael 3/1/2022 michael@gmail.com Retail 100000
ISNUMBER
0 0
FALSE
TRUE
FALSE
TRUE
SUBSTITUTE
Business Resources
TODAY
1/5/2025
YEAR
2022
NOW
1/5/2025 9:36
MONTH
3
