PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I WILL REALLY APPRECIATE. THANKS

1 K L M N Q R S T 1 2 3 4 5 6 7 A B Date Product 1-10-11 Bellen 1-5-11 Bellen 1-28-11 Bellen 1-10-11 Bellen 1-25-11 Bellen 1-5-11 Bellen 1-12-11 Bellen 1-25-11 Bellen 1-30-11 Bellen 1-10-11 Bellen 1-12-11 Bellen 1-11-11 Bellen 1-20-11 Bellen 1-12-11 Bellen E F Region SalesRep Customer Units East Pham HII East Smith GRR East Smith TTT Midwest Smith MidWest Gault WFMI MidWest Chin AA Midwest Franks EPP Midwest Pham MBG Midwest Pham FRED MidWest Gault TTT Midwest Gault MNGD Midwest Gault TRU South Pham ZAT South Sioux AST G H Sales COGS 26 $597.74 $260.00 10 $229.90 $100.00 45 $1,034.55 $450.00 13 $298.87 $130.00 28 $643.72 $280.00 57 $1,310.43 $570.00 22 $505.78 $220.00 10 $229.90 $100.00 10 $229.90 $100.00 50 $1,149.50 $500.00 64 $1,471.36 $640.00 19 $436.81 $190.00 28 $643.72 $280.00 50 $1,149.50 $500.00 You are required to prepare a report, using the function Subtotal, to sum this data based on Region. The fields that should be subtotalled are Sales and COGS. Additionally, you should also count how many transactions there are based on the above instructions. 8 9 10 11 12 13 14 15 D E F G H K K LM N o P Q R S KBTB QT 16 17 18 19 20 21 LOP DDH JAQ A B 1-2-11 Bellen 1-23-11 Bellen 1-11-11 Bellen 1-8-11 Bellen 1-14-11 Bellen 1-19-11 Bellen 1-1-11 Bellen 1-29-11 Bellen 1-12-11 Bellen 1-11-11 Bellen 1-13-11 Carlota 1-9-11 Carlota 1-10-11 Carlota 1-21-11 Carlota 1-4-11 Carlota South South South South South South West West West West East 22 23 24 Smith Pham Smith Smith Gault Gault Franks Smith Smith Chin Sioux Gault Pham Gault Gault DFGH PSA EPP 17 $390.83 19 $436.81 15 $344.85 63 $1,448.37 52 $1,195.48 10 $229.90 24 $551.76 20 $459.80 6 $137.94 57 $1,310.43 60 $1,439.40 10 $239.90 9 $215.91 32 $767.68 33 $791.67 $170.00 $190.00 $150.00 $630.00 $520.00 $100.00 $240.00 $200.00 $60.00 $570.00 $660.00 $110.00 $99.00 $352.00 $363.00 PCC 25 26 27 28 MBG ET FM East East TTT 29 AA East East 30 MBG 31 32 33 34 MBG JAQ MNGD PLOT 35 TRU FM $121.00 36 37 38 39 1-1-11 Carlota 1-16-11 Carlota 1-25-11 Carlota 1-28-11 Carlota 1-22-11 Carlota 1-6-11 Carlota 1-5-11 Carlota 1-3-11 Carlota 1-23-11 Carlota 1-28-11 Carlota 1-25-11 Carlota 1-14-11 Carlota 1-28-11 Carlota 1-15-11 Carlota 1-8-11 Carlota East Smith Midwest Franks MidWest Chin Midwest Pham MidWest Sioux MidWest Gault MidWest Gault South Gault South Gault South Franks South Gault South Sioux South Chin West Smith West Sioux EPP MBG ET 8 $191.92 $88.00 53 $1,271.47 $583.00 13 $311.87 $143.00 62 $1,487.38 $682.00 10 $239.90 $110.00 11 $263.89 47 $1,127.53 $517.00 59 $1,415.41 $649.00 60 $1,439.40 $660.00 19 $455.81 $209.00 21 $503.79 $231.00 48 $1,151.52 $528.00 14 $335.86 $154.00 16 $383.84 $176.00 22 $527.78 $242.00 40 FRED FRED 41 42 ITW 43 44 | KBTB DFR TTT 45 E F K L M M N o Q R LOP TTT HII FM DFR PSA YTR 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 A B ----- 1-22-11 Carlota 1-12-11 Quad 1-11-11 Quad 1-6-11 Quad 1-17-11 Quad 1-25-11 Quad 1-12-11 Quad 1-13-11 Quad 1-3-11 Quad 1-24-11 Quad 1-14-11 Quad 1-25-11 Quad 1-5-11 Quad 1-23-11 Quad 1-28-11 Quad D --- West Pham East Gault East Smith East Franks East Pham East Sioux East Chin East Pham Midwest Gault Midwest Franks MidWest Gault Midwest Pham MidWest Chin Midwest Smith MidWest Smith H -- 45 $1,079.55 $495.00 36 $971.64 $522.00 62 $1,673.38 $899.00 50 $1,349.50 $725.00 43 $1,160.57 $623.50 50 $1,349.50 $725.00 59 $1,592.41 $855.50 27 $728.73 $391.50 361 $971.64 $522.00 61 $1,646.39 $884.50 29 $782.71 $420.50 11 $296.89 $159.50 54 $1,457.46 $783.00 50 $1,349.50 $725.00 301 $809.70 $435.00 SFWK FM | ET ITTW PSA MBG FM A B E F G K L M. N O R 61 62 63 64 65 66 EPP TTT KBTB SFWK ITW QT 67 68 69 70 71 72 73 74 75 1-26-11 Quad 1-24-11 Quad 1-24-11 Quad 1-17-11 Quad 1-26-11 Quad 1-26-11 Quad 1-10-11 Quad 1-3-11 Quad 1-14-11 Quad 1-2-11 Quad 1-8-11 Quad 1-19-11 Quad 1-17-11 Quad 1-23-11 Quad 1-15-11 Quad Midwest Pham South Smith South Franks South Franks South Sioux South Sioux South Chin South Pham West Chin West Chin West Smith West Franks West Smith West Gault West Pham PLOT WSD TRU TTT BBT PLOT | KBTB KPSA ET 17 $458.83 $246.50 56 $1,511.44 $812.00 9 $242.91 $130.50 42 $1,133.58 $609.00 20 $539.80 $290.00 17 $458.83 $246.50 43 $1,160.57 $623.50 32 $863.68 $464.00 43 $1,160.57 $623.50 22 $593.78 $319.00 26 $701.74 $377.00 57 $1,538.43 $826.50 47 $1,268.53 $681.50 31 $836.69 $449.50 55 $1,484.45 $797.50 76 77 78 79 80 82 83 84 85 86 87 88 1-20-11 Sunset East Gault 1-26-11 Sunset East Franks 1-23-11 Sunset East Gault 1-23-11 Sunset Midwest Pham 1-6-11 Sunset Midwest Pham 1-29-11 Sunset South Gault 1-2-11 Sunset South Sioux 1-5-11 Sunset South Smith 1-5-11 Sunset South Sioux 1-20-11 Sunset South Pham 1-30-11 Sunset West Smith 1-26-11 Sunset West Sioux 1-13-11 Sunshine East Gault 1-18-11 Sunshine East Pham 11 bis Tract Cault WSD TTT AST ITTW TRU TRU KPSA KPSA AST AA DFGH FM WT WSD 7 $146.93 $64.75 29 $608.71 $268.25 29 $608.71 $268.25 23 $482.77 $212.75 30 $629.70 $277.50 53 $1,112.47 $490.25 58 $1,217.42 $536.50 39 $818.61 $360.75 23 $482.77 $212.75 21 $440.79 $194.25 23 $482.77 $212.75 50 $1,049.50 $462.50 50 $949.50 $400.00 51 $968.49 $408.00 can no 89 nn 11 99 on 90 T 91 92 93 EPP EPP MNGD PSA 94 MNGD 95 96 97 98 1-13-11 Sunshine East Gault 1-24-11 Sunshine East Pham 1-29-11 Sunshine East Sioux 1-20-11 Sunshine East Franks 1-25-11 Sunshine Midwest Smith 1-22-11 Sunshine Midwest Smith 1-25-11 Sunshine MidWest Sioux 1-5-11 Sunshine Midwest Franks 1-4-11 Sunshine MidWest Sioux 1-6-11 Sunshine South Smith 1-13-11 Sunshine South Pham 1-9-11 Sunshine South Smith 1-18-11 Sunshine South Smith 1-24-11 Sunshine West Pham 1-2-11 Sunshine West Sioux 11 $208.89 57 $1,082.43 40 $759.60 64 $1,215.36 26 $493.74 29 $550.71 55 $1,044.45 14 $265.86 37 $702.63 53 $1,006.47 62 $1,177.38 22 $417.78 62 $1,177.38 41 $778.59 16 $303.84 $88.00 $456.00 $320.00 $512.00 $208.00 $232.00 $440.00 $112.00 $296.00 $424.00 $496.00 $176.00 $496.00 $328.00 $128.00 PLOT QT TRU WFMI AA ET ITTW 99 100 101 102 103 104 TTT 105 106 1-9-11 Sunshine West 1-22-11 Sunshine West Franks Smith EPP WT 45 $854.55 $360.00 64 $1,215.36 $512.00