ANALYTICS EXCEL MATH QUESTION:

Please see the attached excel screenshot of the $2$ data tables. Please provide the correct excel formulas such as: COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGE, AVERAGEIF to solve both of the data tables. Provide the correct formulas for the first chart and advise if the second chart is correct, and provide the correct ones if not. Please see the function bar in the screenshot for reference.

The columns G$,$ H$,$ and I go to cell number $449$

The prompt for chart $1$ is:

The table of data beginning in Column G shows yards gained in rushing and passing plays for NFL teams. Determine the Total Yards and Average Yards gained per play by each team in running and passing plays.

The prompt for chart $2$ is:

Use the same data and count how many plays were running or passing.