Lesa has asked you to analyze the sales per banquet room.

On the RoomAnalysis worksheet, in cell G$7,$ determine the total charges for the Musica Room by using a SUMIF function. Use absolute references where appropriate. Copy this formula through cell G$11,$ if necessary.

Lesa also want to know the number of times each room was used in the month of January.

In cell G$16,$ determine the total count of the Musica Room usage by using a COUNTIF function. Use absolute references where appropriate. Copy this formula through cell G$20,$ if necessary.

Add the File Name code in the left footer of the Renovations and RoomAnalysis worksheets.

Save and close Excel Ch$03$ PS$1$ Renovationsxisx. Exit Excel. Submit the file as directed.