Need help solving this, show step by step

6. In the range 13:17, Hwan wants to summarize project information. Calculate the number of projects, the total estimates, and the average estimate in each category as follows: a. In cell 34, enter a formula using the COUNTIF function that counts the number of projects in the Bridge category, checking that the column of categories in the Projects table (Projects[Category]) is equal to the value in cell 14. b. Fill the range 35:17 with the formula in cell 34, filling without formatting. c. In cell K4, enter a formula using the SUMIF function that totals the estimates for projects in the Bridge category, checking that the column of categories in the Projects table (Projects[Category]) is equal to the value in cell 14, and that the formula totals the values in the Estimate column (Projects[Estimate]). d. Fill the range K5:K7 with the formula in cell K4, filling without formatting. e. In cell L4, enter a formula using the AVERAGEIF function that averages the estimates of projects in the Bridge category, checking that the column of categories in the Projects table (Projects[Category]) is equal to the value in cell 14, and that the formula averages the values in the Estimate column (Projects[Estimate]). f. Fill the range L5:L7 with the formula in cell L4, filling without formatting. File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Record Macro Use Relative References Properties View Code Insert Design Mode Run Dialog Map Properties Import Expansion Packs E Export Refresh Data Source Visual Macros Basic Add- ins Excel COM Add-ins Add-ins ! Macro Security v Code Add-ins Controls XML G2 fix C D E F H I K L M N. Engineering Projects Print Stats 1 2 3 Category State Project Start 4 Highway NE 1/12/2021 5 Highway NE 1/20/2021 6 Bridge WY 2/16/2021 7 Site development NE 2/22/2021 8 Site development SD 2/22/2021 9 Paving ND 3/1/2021 10 Bridge NE 3/12/2021 11 Site development WY 3/20/2021 12 Site enhancement NE 3/23/2021 13 Paving ND 3/24/2021 14 Paving MT 3/30/2021 15 Paving NE 4/2/2021 16 Paving SD 4/2/2021 17 Paving MT 4/5/2021 18 Bridge WY 4/5/2021 19 Paving ND 4/14/2021 20 Paving MT 4/16/2021 21 Parring 1/16/2021 Documentation Projects Project Stats Estimate Paid to Date - Category Projects Total EstimatesAvg Estimates $30,562 $30,562 Bridge $14,500 $12,000 Highway $54,672 $50,000 Paving $107,654 $57,654 Site development $38,750 $30,000 $48,932 $45,932 Estimate $72,358 $72,358 >50,000 $24,505 $24,505 Projects: $34,756 $34,756 $68,900 $34,900 Client ID $42,350 $4,250 W-0338 $27,800 $17,000 Total paid: $28,500 $28,500 $70,347 $30,400 Projects by State $19,576 $10,576 MT $78,400 $38,400 ND $76,320 $16,320 NE 552050 $12050 SD Projects by State Project Payments Projects by Category Monthly Sal + Ready EO File Home Insert Page Layout Formulas Data Review View Developer Help Tell me what you want to do Record Macro Use Relative References E Properties QE View Code Insert Design Mode Run Dialog Map Properties Import Expansion Packs Export Refresh Data Source Visual Macros Basic Add- ins ! Macro Security Excel COM Add-ins Add-ins Code Add-ins Controls XML G2 X fic D I K L Projects by State 16 Paving SD 17 Paving MT 18 Bridge WY 19 Paving ND 20 Paving MT 21 Paving MT 22 Highway SD 23 Paving NE 24 Site development WY 25 Paving ND 26 Bridge MT 27 Highway SD 28 Highway ND 29 Site development SD 30 Paving 31 Highway MT 32 Paving WY 33 Paving NE 34 Site development NE 35 Site development SD 36 Highway ND 37 Paving NE 38 39 Documentation E 4/2/2021 4/5/2021 4/5/2021 4/14/2021 4/16/2021 4/16/2021 4/17/2021 4/23/2021 5/2/2021 5/10/2021 5/14/2021 5/14/2021 5/26/2021 5/30/2021 6/1/2021 6/3/2021 6/6/2021 6/12/2021 6/17/2021 6/20/2021 6/24/2021 6/26/2021 F $28,500 $70,347 $19,576 $78,400 $76,320 $52,050 $56,890 $34,560 $19,750 $34,566 $29,800 $24,528 $18,500 $85,437 $82,350 $31,250 $75,250 $100,350 $34,582 $44,500 $82,300 $37,650 H $28,500 $30,400 $10,576 MT $38,400 ND $16,320 NE $12,050 SD $6,000 WY $17,000 $2,000 $24,000 $20,000 $2,400 $18,500 $43,000 $40,000 $11,250 $7,500 $10,350 $14,582 $20,500 $42,000 $17,000 NE Projects Project Stats Projects by State Project Payments Projects by Category Monthly Sal ... + Ready EO