What is a formula that i can use to figure out the sum and average of each month using the SUMIFS and AVERAGEIFS functions?

1. You will create a summary that includes the following for each month of the year: (30 points) Here is example showing the first two months of the year. Month Total Sales Average Sales January February Use functions SUMIFS and AVERAGEIFS to determine the total and average sales per month. 1 Date 2 3 4 3 4 5. 6 B 7 8 9 10 11 12 13 14 15 16 17 B Total Spent February 25, 2017 $3,540.47 May 22, 2017 $1,800.59 April 24, 2017 $1,898.77 July 22, 2017 $3,707.33 December 19, 2017 $720.26 September 8, 2017 $3,448.87 January 12, 2017 $3,002.26 February 16, 2017 $3,927.16 July 25, 2017 $2,789.16 April 13, 2017 $962.24 March 31, 2017 $4,676.18 May 20, 2017 $2,951.52 February 22, 2017 $1,591.96 June 16, 2017 $4,482.39 March 27, 2017 $2,311.30 April 14, 2017 $1,363.67 April 2, 2017 $836.23 August 23, 2017 $4,799.69 November 5, 2017 $4,167.33 January 8, 2017 $2,114.05 January 4, 2017 $2,857.94 July 27, 2017 $4,287.27 April 22, 2017 $1,625.67 March 14, 2017 $3,586.00 May 7, 2017 $2,415.38 April 26, 2017 $4,390.37 March 19, 2017 $2,179.46 18 19 20 21 22 23 24 25 26 27 28