Lookup+sum+max

[aarky]

On which country did the company spend the most money in Salaries in 2022? Employee ID Full Name Job Title Department Business Unit Gender Ethnicity Age Hire Date year Salary Per Month Bonus % Country City Exit Date BHR02002 Kai Le Controls Engineer Technology & Engineering Manufacturing Male Asian 47​ 2/5/2022​ 2022​ KD 2,386.17 0​ United States Columbus BHR02003 Robert Patel Analyst Purchase & Sales Corporate Male Asian 58​ 10/23/2013​ 2013​ KD 1,180.66 0​ United States Chicago BHR02004 Cameron Lo Network Administrator Computer & Information Technology Research & Development Male Asian 34​ 3/24/2019​ 2019​ KD 2,159.05 0​ China Shanghai BHR02005 Harper Castillo IT Systems Architect Computer & Information Technology Corporate Female Latino 39​ 4/7/2018​ 2018​ KD 2,533.27 0​ United States Seattle BHR02006 Harper Dominguez Director Technology & Engineering Corporate Female Latino 42​ 6/18/2005​ 2005​ KD 4,530.93 0.24​ United States Austin BHR02007 Ezra Vu Network Administrator Computer & Information Technology Manufacturing Male Asian 62​ 4/22/2004​ 2004​ KD 1,710.86 0​ United States Phoenix 2/14/2014​ BHR02008 Jade Hu Sr. Analyst Accounting & Operations Specialty Products Female Asian 58​ 6/27/2009​ 2009​ KD 2,318.39 0​ China Chongqing BHR02009 Miles Chang Analyst II Finance Corporate Male Asian 62​ 2/19/1999​ 1999​ KD 1,799.91 0​ China Chengdu BHR02010 Gianna Holmes System Administrator Computer & Information Technology Manufacturing Female Caucasian 38​ 9/9/2011​ 2011​ KD 2,522.11 0​ United States Seattle BHR02011 Jameson Thomas Manager Finance Specialty Products Male Caucasian 52​ 2/5/2015​ 2015​ KD 2,735.21 0.1​ United States Miami BHR02012 Jameson Pena Systems Analyst Computer & Information Technology Manufacturing Male Latino 49​ 10/12/2003​ 2003​ KD 1,046.22 0​ United States Miami BHR02013 Bella Wu Sr. Analyst Finance Specialty Products Female Asian 63​ 8/3/2014​ 2014​ KD 1,844.97 0​ United States Phoenix BHR02014 Jose Wong Director Computer & Information Technology Manufacturing Male Asian 45​ 11/15/2017​ 2017​ KD 3,889.42 0.23​ China Chongqing BHR02015 Lucas Richardson Manager Marketing Corporate Male Caucasian 36​ 7/22/2018​ 2018​ KD 3,071.89 0.08​ United States Miami BHR02016 Jacob Moore Sr. Manager Marketing Corporate Male Black 42​ 3/24/2021​ 2021​ KD 3,395.07 0.15​ United States Phoenix BHR02017 Luna Lu IT Systems Architect Computer & Information Technology Corporate Female Asian 62​ 7/26/1997​ 1997​ KD 1,658.71 0​ United States Miami BHR02018 Bella Tran Vice President Technology & Engineering Specialty Products Female Asian 45​ 8/5/2010​ 2010​ KD 6,574.22 0.33​ China Chengdu BHR02019 Ivy Chau Analyst Purchase & Sales Specialty Products Female Asian 61​ 3/3/2019​ 2019​ KD 1,415.95 0​ China Chongqing BHR02020 Jordan Kumar Service Desk Analyst Computer & Information Technology Specialty Products Male Asian 29​ 11/11/2017​ 2017​ KD 2,473.00 0​ United States Seattle BHR02021 Sophia Gutierrez Manager Accounting & Operations Specialty Products Female Latino 63​ 2/8/2009​ 2009​ KD 2,651.77 0.06​ United States Austin BHR02022 Eli Dang Sr. Manager Accounting & Operations Specialty Products Male Asian 45​ 11/16/2015​ 2015​ KD 3,174.27 0.12​ United States Chicago BHR02023 Lillian Lewis Technical Architect Computer & Information Technology Research & Development Female Black 43​ 8/14/2013​ 2013​ KD 2,152.51 0​ United States Phoenix 3/31/2019​ BHR02024 Serenity Cao Account Representative Purchase & Sales Manufacturing Female Asian 31​ 10/21/2018​ 2018​ KD 1,723.63 0​ China Shanghai BHR02025 Parker Lai Vice President Accounting & Operations Specialty Products Male Asian 48​ 11/29/2006​ 2006​ KD 6,365.33 0.36​ China Chongqing BHR02026 Charles Simmons Manager Purchase & Sales Specialty Products Male Caucasian 55​ 10/27/1997​ 1997​ KD 2,932.73 0.06​ United States Miami BHR02027 Jayden Luu Director Accounting & Operations Manufacturing Male Asian 64​ 5/13/2004​ 2004​ KD 4,762.17 0.22​ China Beijing BHR02028 Brooks Richardson Director Marketing Specialty Products Male Caucasian 58​ 11/24/2020​ 2020​ KD 3,909.64 0.22​ United States Seattle BHR02029 Ivy Thompson Manager Marketing Manufacturing Female Caucasian 50​ 8/11/2004​ 2004​ KD 3,071.58 0.05​ United States Seattle BHR02030 Peyton Wright Sr. Manager Marketing Corporate Female Black 41​ 5/13/2017​ 2017​ KD 3,962.06 0.1​ United States Chicago BHR02031 Wyatt Dinh System Administrator Computer & Information Technology Specialty Products Male Asian 50​ 3/15/2002​ 2002​ KD 1,882.22 0​ China Shanghai BHR02032 Ruby Alexander Vice President Finance Research & Development Female Caucasian 59​ 8/13/2001​ 2001​ KD 6,603.26 0.36​ United States Phoenix BHR02033 Axel Oh Sr. Analyst Purchase & Sales Corporate Male Asian 26​ 10/24/2020​ 2020​ KD 2,194.85 0​ China Chengdu BHR02034 Axel Ramirez Manager HR Specialty Products Male Latino 55​ 12/4/2017​ 2017​ KD 2,681.37 0.07​ United States Seattle BHR02035 Liliana Chang Service Desk Analyst Computer & Information Technology Corporate Female Asian 32​ 1/11/2018​ 2018​ KD 2,518.98 0​ China Shanghai BHR02036 Leonardo Carter Business Partner HR Specialty Products Male Caucasian 50​ 9/7/2022​ 2022​ KD 1,419.05 0​ United States Austin BHR02037 Landon Gonzales Test Engineer Technology & Engineering Specialty Products Male Latino 54​ 8/30/2009​ 2009​ KD 2,291.13 0​ United States Phoenix BHR02038 Amelia Dominguez Sr. Manager Accounting & Operations Corporate Female Latino 31​ 9/23/2015​ 2015​ KD 4,086.42 0.15​ Brazil Rio de Janeiro 7/27/2018​ BHR02039 Silas Ross Analyst Marketing Research & Development Male Caucasian 47​ 2/10/2016​ 2016​ KD 1,253.51 0​ United States Austin BHR02040 Jeremiah Cheng Sr. Analyst Marketing Specialty Products Male Asian 26​ 2/5/2022​ 2022​ KD 600,000.00 0​ China Shanghai BHR02041 Chloe Chin Sr. Manager Finance Specialty Products Female Asian 62​ 11/13/2021​ 2021​ KD 3,474.25 0.1​ United States Seattle BHR02042 Ella Martinez Sr. Analyst Finance Research & Development Female Latino 35​ 4/6/2012​ 2012​ KD 1,966.20 0​ United States Chicago BHR02043 Gianna Jones Manager Accounting & Operations Research & Development Female Caucasian 48​ 9/26/1998​ 1998​ KD 3,079.85 0.09​ United States Columbus 11/2/2016​ BHR02044 Austin Chow Vice President Accounting & Operations Manufacturing Male Asian 35​ 4/11/2021​ 2021​ KD 4,672.17 0.32​ China Chongqing BHR02045 Ella Chen Manager Accounting & Operations Specialty Products Female Asian 45​ 11/10/2005​ 2005​ KD 2,946.86 0.08​ United States Phoenix BHR02046 Ruby Kaur Test Engineer Technology & Engineering Research & Development Female Asian 26​ 6/26/2021​ 2021​ KD 2,368.19 0​ China Beijing BHR02047 Savannah Morales Analyst II Marketing Corporate Female Latino 48​ 1/26/2005​ 2005​ KD 1,848.17 0​ United States Chicago BHR02048 Luca Powell IT Coordinator Computer & Information Technology Specialty Products Male Caucasian 33​ 12/18/2016​ 2016​ KD 1,413.08 0​ United States Miami BHR02049 Parker Thao Analyst II Purchase & Sales Corporate Male Asian 55​ 5/8/2011​ 2011​ KD 1,679.74 0​ China Chongqing BHR02050 Ryan Vo Cloud Infrastructure Architect Computer & Information Technology Research & Development Male Asian 38​ 4/12/2011​ 2011​ KD 1,681.98 0​ United States Phoenix BHR02051 Isabella Ngo Manager Accounting & Operations Specialty Products Female Asian 49​ 1/1/2022​ 2022​ KD 3,270.45 0.09​ United States Miami BHR02052 Leah Vega Cloud Infrastructure Architect Computer & Information Technology Corporate Female Latino 52​ 6/7/2018​ 2018​ KD 1,870.02 0​ United States Miami BHR02053 Jaxson Liu Vice President Finance Corporate Male Asian 27​ 5/18/2021​ 2021​ KD 5,301.41 0.36​ United States Chicago BHR02054 Santiago f Ross Enterprise Architect Computer & Information Technology Specialty Products Male Caucasian 34​ 12/13/2012​ 2012​ KD 1,911.77 0​ United States Columbus BHR02055 Layla Bell Vice President Technology & Engineering Corporate Female Caucasian 65​ 7/26/2001​ 2001​ KD 5,244.94 0.31​ United States Chicago BHR02056 Bella Morales Director Purchase & Sales Specialty Products Female Latino 38​ 5/10/2016​ 2016​ KD 5,033.99 0.24​ United States Austin BHR02057 Eliza Kang Computer Systems Manager Computer & Information Technology Manufacturing Female Asian 63​ 1/27/2002​ 2002​ KD 1,980.36 0.05​ United States Phoenix BHR02058 Gabriel Reyes Manager Purchase & Sales Corporate Male Latino 42​ 6/10/2005​ 2005​ KD 2,625.44 0.08​ Brazil Sao Paulo BHR02059 Piper Garcia Sr. Manager Purchase & Sales Research & Development Female Latino 60​ 11/24/1993​ 1993​ KD 3,279.00 0.12​ Brazil Sao Paulo BHR02060 Jacob Cheng Director Purchase & Sales Manufacturing Male Asian 47​ 11/26/1999​ 1999​ KD 4,027.16 0.17​ United States Columbus #########​ BHR02061 Nathan Hong Director Finance Corporate Male Asian 50​ 10/2/2019​ 2019​ KD 3,891.30 0.17​ United States Phoenix BHR02062 Chloe Kim Sr. Analyst Purchase & Sales Specialty Products Female Asian 39​ 7/6/2012​ 2012​ KD 1,881.96 0​ United States Miami BHR02063 Isaac Guzman Account Representative Purchase & Sales Corporate Male Latino 46​ 8/18/2010​ 2010​ KD 1,497.07 0​ United States Phoenix BHR02064 Julian Ford Analyst II Purchase & Sales Manufacturing Male Caucasian 50​ 7/29/2010​ 2010​ KD 1,817.12 0​ United States Miami BHR02065 Kinsley Liang Automation Engineer Technology & Engineering Manufacturing Female Asian 55​ 8/25/2008​ 2008​ KD 2,537.38 0​ China Shanghai BHR02066 Wesley Yu Sr. Manager Purchase & Sales Specialty Products Male Asian 43​ 9/24/2003​ 2003​ KD 3,285.35 0.12​ United States Seattle BHR02067 Serenity Martin Sr. Analyst Finance Manufacturing Female Black 26​ 5/16/2021​ 2021​ KD 2,519.84 0​ United States Phoenix BHR02068 Ethan Sanchez Sr. Analyst Marketing Research & Development Male Latino 34​ 5/15/2019​ 2019​ KD 2,109.19 0​ United States Phoenix BHR02069 David Sanchez Director Purchase & Sales Specialty Products Male Latino 38​ 7/5/2009​ 2009​ KD 4,703.09 0.27​ Brazil Rio de Janeiro BHR02070 Elias Hsu Sr. Analyst Marketing Specialty Products Male Asian 35​ 1/23/2022​ 2022​ KD 2,241.74 0​ China Chengdu BHR02071 Luca Phan Manager Marketing Corporate Male Asian 39​ 6/17/2015​ 2015​ KD 3,357.02 0.09​ China Beijing BHR02072 Olivia Xi Manager Purchase & Sales Specialty Products Female Asian 26​ 8/19/2020​ 2020​ KD 3,217.15 0.06​ United States Chicago BHR02073 Alice Luu System Administrator Computer & Information Technology Research & Development Female Asian 60​ 7/17/1993​ 1993​ KD 2,094.64 0​ United States Columbus BHR02074 Leonardo Ng Analyst Marketing Corporate Male Asian 32​ 6/10/2019​ 2019​ KD 1,491.28 0​ China Chengdu BHR02075 Peyton Edwards Analyst II Finance Manufacturing Female Caucasian 65​ 7/11/2020​ 2020​ KD 1,533.05 0​ United States Columbus BHR02076 Axel Patel Sr. Analyst Purchase & Sales Research & Development Male Asian 27​ 9/13/2022​ 2022​ KD 1,891.08 0​ United States Miami BHR02077 Eva Chavez IT Systems Architect Computer & Information Technology Specialty Products Female Latino 63​ 1/17/2004​ 2004​ KD 2,145.98 0​ Brazil Sao Paulo BHR02078 Savannah Lee Manager HR Research & Development Female Asian 51​ 7/22/2020​ 2020​ KD 2,686.87 0.1​ China Beijing BHR02079 Mia Grant Solutions Architect Computer & Information Technology Corporate Female Caucasian 43​ 2/16/2007​ 2007​ KD 1,832.18 0​ United States Columbus BHR02080 Eli Richardson Sr. Manager Marketing Specialty Products Male Black 31​ 4/8/2018​ 2018​ KD 4,110.63 0.14​ United States Phoenix BHR02081 Eloise Perry Sr. Business Partner HR Research & Development Female Caucasian 26​ 12/2/2020​ 2020​ KD 2,297.13 0​ United States Chicago BHR02082 Ian Cheng Sr. Manager Purchase & Sales Specialty Products Male Asian 46​ 8/30/2015​ 2015​ KD 3,273.19 0.14​ United States Phoenix BHR02083 Penelope Chan Analyst II Accounting & Operations Manufacturing Female Asian 59​ 5/20/2012​ 2012​ KD 1,490.69 0​ China Shanghai #########​ BHR02084 Sofia Vasquez Director Purchase & Sales Research & Development Female Latino 52​ 7/29/1996​ 1996​ KD 4,945.92 0.24​ Brazil Sao Paulo BHR02085 Anthony Baker Solutions Architect Computer & Information Technology Manufacturing Male Caucasian 31​ 6/3/2021​ 2021​ KD 2,581.71 0​ United States Phoenix BHR02086 Lucas Luong Analyst Marketing Specialty Products Male Asian 42​ 3/12/2008​ 2008​ KD 1,053.43 0​ China Chengdu BHR02087 Xavier Patel Director Marketing Specialty Products Male Asian 53​ 11/16/2021​ 2021​ KD 4,849.95 0.16​ United States Columbus BHR02088 Robert Soto HRIS Analyst HR Research & Development Male Latino 47​ 9/10/2008​ 2008​ KD 1,869.92 0​ Brazil Rio de Janeiro BHR02089 Nevaeh Jiang Sr. Manager Marketing Corporate Female Asian 45​ 8/5/2016​ 2016​ KD 3,702.38 0.12​ China Chengdu BHR02090 Chloe Reyes Director HR Specialty Products Female Latino 45​ 6/18/2008​ 2008​ KD 4,942.02 0.17​ United States Phoenix BHR02091 Lucy Edwards Director HR Specialty Products Female Black 33​ 3/16/2015​ 2015​ KD 4,543.44 0.21​ United States Columbus 5/16/2022​ BHR02092 Luna Edwards Manager Purchase & Sales Research & Development Female Black 42​ 4/13/2014​ 2014​ KD 2,757.09 0.09​ United States Seattle BHR02093 Stella Daniels Cloud Infrastructure Architect Computer & Information Technology Manufacturing Female Black 37​ 10/30/2011​ 2011​ KD 1,876.46 0​ United States Columbus BHR02094 Ayla Ma Manager Marketing Corporate Female Asian 27​ 12/5/2022​ 2022​ KD 3,056.19 0.07​ China Shanghai BHR02095 Matthew Avila Computer Systems Manager Computer & Information Technology Manufacturing Male Latino 55​ 6/17/2003​ 2003​ KD 1,771.96 0.08​ Brazil Sao Paulo BHR02096 Gianna Lim Analyst Accounting & Operations Research & Development Female Asian 46​ 4/1/2006​ 2006​ KD 1,098.74 0​ China Chongqing BHR02097 Joseph Tan Technical Architect Computer & Information Technology Research & Development Male Asian 37​ 8/20/2015​ 2015​ KD 1,681.05 0​ China Shanghai BHR02098 Connor Lai Engineering Manager Technology & Engineering Corporate Male Asian 32​ 9/22/2019​ 2019​ KD 2,868.40 0.12​ United States Chicago BHR02099 Ava Owens Analyst II Finance Specialty Products Female Caucasian 28​ 2/7/2020​ 2020​ KD 1,629.21 0​ United States Seattle BHR02100 Dylan Aguilar Director Technology & Engineering Corporate Male Latino 49​ 3/27/2007​ 2007​ KD 4,809.96 0.27​ Brazil Sao Paulo BHR02101 Leah Zheng Director Technology & Engineering Corporate Female Asian 52​ 6/18/2016​ 2016​ KD 4,725.90 0.23​ China Chengdu BHR02102 Jade Pham Analyst Accounting & Operations Manufacturing Female Asian 61​ 12/12/2017​ 2017​ KD 1,393.22 0​ China Shanghai BHR02103 Theodore Bui Vice President Purchase & Sales Specialty Products Male Asian 53​ 5/13/2012​ 2012​ KD 6,513.62 0.38​ China Beijing BHR02104 Asher Chan Sr. Business Partner HR Corporate Male Asian 40​ 8/18/2018​ 2018​ KD 1,886.89 0​ China Shanghai BHR02105 Ezekiel Brown Manager Finance Corporate Male Caucasian 27​ 3/14/2022​ 2022​ KD 3,108.14 0.08​ United States Miami 7/17/2022​ BHR02106 Peyton Allen Manager Marketing Specialty Products Female Caucasian 26​ 11/23/2020​ 2020​ KD 2,900.15 0.05​ United States Chicago BHR02107 Parker Joseph Systems Analyst Computer & Information Technology Specialty Products Male Caucasian 53​ 1/21/2000​ 2000​ KD 1,421.84 0​ United States Seattle BHR02108 Kayden Ortiz Sr. Manager Accounting & Operations Specialty Products Male Latino 33​ 7/29/2013​ 2013​ KD 3,481.87 0.15​ Brazil Manaus BHR02109 Lillian Desai Field Engineer Technology & Engineering Manufacturing Female Asian 27​ 12/12/2022​ 2022​ KD 2,397.49 0​ China Chengdu BHR02110 Avery Gutierrez Vice President Marketing Corporate Female Latino 56​ 7/2/2016​ 2016​ KD 4,676.56 0.38​ United States Phoenix BHR02111 Caroline Sandoval Analyst Purchase & Sales Corporate Female Latino 36​ 10/3/2013​ 2013​ KD 1,243.02 0​ Brazil Sao Paulo BHR02112 Hailey Lim Director Marketing Corporate Female Asian 47​ 1/6/2005​ 2005​ KD 4,979.45 0.17​ China Chongqing BHR02113 Roman Liang Sr. Analyst Purchase & Sales Manufacturing Male Asian 28​ 3/4/2021​ 2021​ KD 2,201.16 0​ China Chongqing 7/8/2022​ BHR02114 Elias Rojas Account Representative Purchase & Sales Manufacturing Male Latino 30​ 1/7/2018​ 2018​ KD 1,505.83 0​ United States Chicago

 

[aarky]

I need a solution in old school formula and new school formula.

 

[aarky]

sorry to mention i want single cell formula without helper column. thanks