If someone can help solve this excel problem and provide what formulas were needed to solve it I would highly appreciate it thank you!

Home B HP Calibri Category State Arizona Colorado Idaho Nevada New Mexico Utah Insert Draw Page Layout 11 B Payroll Location State fx D Albuquerque New Mexico Data & A E Boise Idaho Formulas Review View Ev F Colorado Springs Colorado 121,919 232,311 Computer 127,205 121,376 TV 163,601 194,887 Phone 30,186 38,730 41,291 Appliance 281,769 344,077 213,335 Audio 48,607 35,761 42,270 Other 40,222 76.349 78,068 Total Sales Summary by State Number of Stores Sales Goal/Store Average Sales Goal Achieved? 750,000 750,000 750,000 750,000 750,000 750,000 Automate Help ab v General G H Denver Colorado Fort Collins Colorado 143,855 162,596 38,066 239,035 48,832 46,150 144,697 154,718 32,933 233,113 22,521 30,395 Editing +0 .00 .00 0 I Grand Junction Colorado 91,085 216,415 72,631 288,097 36,509 69,460 J K Store Sales by Category Las Cruces New Mexico 111,690 248,214 54,514 301,754 40,135 66,748 Las Vegas Nevada 137,451 108,275 63,012 353,097 18,781 47,821 Share M L Phoenix Arizona 135,718 254,028 84,753 313,285 52,492 43,417 Comments TV Ov M Pocatello Idaho 135,350 117,031 48,613 283,608 38,589 73,689 N Provo Utah 83,41 209,73 56,63 208,93 43,55 70,26 Home Insert d MP Calibri X G Denver Colorado F ado Springs olorado 121,919 232,311 41,291 213,335 42,270 78,068 Achieved? Payroll Draw Page Layout 11 B H Fort Collins Grand Junction Colorado Colorado 143,855 162,596 38,066 239,035 48,832 46,150 Formulas 144,697 154,718 32,933 233,113 22,521 30,395 Data Review View & A J K Store Sales by Category Las Cruces New Mexico 111,690 248,214 54,514 301,754 40,135 66,748 91,085 216,415 72,631 288,097 36,509 69,460 Las Vegas Nevada 137,451 108,275 63,012 353,097 18,781 47,821 Automate Help ab v General M Phoenix Arizona Pocatello Idaho 135,350 117,031 48,613 283,608 38,589 73,689 135,718 254,028 84,753 313,285 52,492 43,417 Editing .00 .00 0 N Provo Utah +0 83,410 209,736 56,637 208,936 43,556 70,261 0 Reno Nevada Share Q R Tucson Arizona St. George Utah 137,433 229,075 22,028 312,354 26,217 60,286 ^[ ^4 ^ ^ 116,260 288,558 23,107 218,031 54,754 42,341 Comments P Salt Lake City Utah 119,461 110,414 83,575 303,810 59,603 74,382 139,824 104,914 71,339 399,539 34,826 62,434 S Max I Home Q St. George Utah 137,433 229,075 22,028 312,354 26,217 60,286 Payroll Insert Draw Page Layout Calibri 11 B R S Tucson Max Arizona 139,824 104,914 71,339 399,539 34,826 62,434 Formulas Data Review View & A *** = U V T Average W X Automate Help ab v General Y Z AA Editing +0 .00 .00 0 AB AC V AD V Share AF AG AH AE Comments AI Home B HP Calibri Category State Arizona Colorado Idaho Nevada New Mexico Utah Insert Draw Page Layout 11 B Payroll Location State fx D Albuquerque New Mexico Data & A E Boise Idaho Formulas Review View Ev F Colorado Springs Colorado 121,919 232,311 Computer 127,205 121,376 TV 163,601 194,887 Phone 30,186 38,730 41,291 Appliance 281,769 344,077 213,335 Audio 48,607 35,761 42,270 Other 40,222 76.349 78,068 Total Sales Summary by State Number of Stores Sales Goal/Store Average Sales Goal Achieved? 750,000 750,000 750,000 750,000 750,000 750,000 Automate Help ab v General G H Denver Colorado Fort Collins Colorado 143,855 162,596 38,066 239,035 48,832 46,150 144,697 154,718 32,933 233,113 22,521 30,395 Editing +0 .00 .00 0 I Grand Junction Colorado 91,085 216,415 72,631 288,097 36,509 69,460 J K Store Sales by Category Las Cruces New Mexico 111,690 248,214 54,514 301,754 40,135 66,748 Las Vegas Nevada 137,451 108,275 63,012 353,097 18,781 47,821 Share M L Phoenix Arizona 135,718 254,028 84,753 313,285 52,492 43,417 Comments TV Ov M Pocatello Idaho 135,350 117,031 48,613 283,608 38,589 73,689 N Provo Utah 83,41 209,73 56,63 208,93 43,55 70,26 Home Insert d MP Calibri X G Denver Colorado F ado Springs olorado 121,919 232,311 41,291 213,335 42,270 78,068 Achieved? Payroll Draw Page Layout 11 B H Fort Collins Grand Junction Colorado Colorado 143,855 162,596 38,066 239,035 48,832 46,150 Formulas 144,697 154,718 32,933 233,113 22,521 30,395 Data Review View & A J K Store Sales by Category Las Cruces New Mexico 111,690 248,214 54,514 301,754 40,135 66,748 91,085 216,415 72,631 288,097 36,509 69,460 Las Vegas Nevada 137,451 108,275 63,012 353,097 18,781 47,821 Automate Help ab v General M Phoenix Arizona Pocatello Idaho 135,350 117,031 48,613 283,608 38,589 73,689 135,718 254,028 84,753 313,285 52,492 43,417 Editing .00 .00 0 N Provo Utah +0 83,410 209,736 56,637 208,936 43,556 70,261 0 Reno Nevada Share Q R Tucson Arizona St. George Utah 137,433 229,075 22,028 312,354 26,217 60,286 ^[ ^4 ^ ^ 116,260 288,558 23,107 218,031 54,754 42,341 Comments P Salt Lake City Utah 119,461 110,414 83,575 303,810 59,603 74,382 139,824 104,914 71,339 399,539 34,826 62,434 S Max I Home Q St. George Utah 137,433 229,075 22,028 312,354 26,217 60,286 Payroll Insert Draw Page Layout Calibri 11 B R S Tucson Max Arizona 139,824 104,914 71,339 399,539 34,826 62,434 Formulas Data Review View & A *** = U V T Average W X Automate Help ab v General Y Z AA Editing +0 .00 .00 0 AB AC V AD V Share AF AG AH AE Comments AI