Excel Formula Project
Company Sales Information RecordColumn1Column2Column3Column4Column5Column6Employee NameTenureOffice LocationMarch SalesApril SalesPhone NumberAnnual SalaryAlice Norman2Dallas, Oregon $ 2,548.00 $ 22,764.00503-902-2155 $ 22,431.00Nathan Morson5LA, California $ 3,669.00 $ 20,866.00531-222-1111 $ 21,609.00Harry Moore9Salem, Oregon $ 4,723.00 $ 23,655.00503-543-6808 $ 20,547.00Lori Walter3Keizer,Oregon $ 3,897.00 $ 45,766.00531-675-8077 $ 25,975.00Henry Morris6Portland, Oregon $ 7,449.00 $ 46,982.00503-380-5498 $ 24,650.00Jacob Mark1Phoenix, Arizona $ 5,493.00 $ 44,211.00531-786-4444 $ 27,098.00Rachel Jefferson12Las Vegas, Nevada $ 3,652.00 $ 43,523.00531-211-8355 $ 25,438.00Jared Marcus4Dallas, Texas $ 3,885.00 $ 36,854.00333-222-1111 $ 28,091.00Kelly Simpson7Mesa, Arizona $ 9,558.00 $ 32,097.00531-444-5555 $ 30,654.00Karina Mason8Miami, Florida $ 8,746.00 $ 31,740.00531-231-7777 $ 33,487.00Mary Dobson11Seattle, Washington $ 5,997.00 $ 24,331.00503-201-8888 $ 32,108.00Kayla Stewart13Tacoma, Washington $ 4,663.00 $ 28,638.00503-896-4589 $ 34,876.00Dan Kristin12Carson City, Nevada $ 2,096.00 $ 30,628.00503-231-0101 $ 25,890.00Joan Lawrence10San Diego, California $ 5,898.00 $ 29,655.00503-888-9999 $ 35,432.00Elizabeth Johnson13Atlanta, Georgia $ 4,211.00 $ 25,899.00503-431-6542 $ 23,990.00Mikey Harrison15New York, New York $ 5,998.00 $ 21,809.00503-807-9021 $ 37,092.00George Burton14Austin, Texas $ 4,674.00 $ 46,877.00503-901-5662 $ 34,885.00Yasmin Harold18Keizer,Oregon $ 4,317.00 $ 42,901.00503-789-7654 $ 33,881.00Mariko Kisaragi20LA, California $ 4,867.00 $ 41,806.00513-732-1329 $ 39,012.00Yuriko Takashi24Boston, MA $ 4,876.00 $ 45,321.00523-543-8095 $ 37,096.00AVERAGE $ 5,060.85 $ 34,316.15 $ 29,712.10COUNT202020SUM $ 101,217.00 $ 686,323.00 $ 594,242.00