Formula totalis the saies for all four quarters. $($Sales Thotal Sales$1).$ Fill the range $05$:$08$ with the formula in cell on

$3.$ In column P$,$ Nadia wants to calculate the averago sales for each category. In cell P$4,$ enter a formula using the AVERAGEIF function that averages the sales for Banking projects, checking that the category columh in the Sales table is equal to the value in cell M$4,$ and that the formula averages the safes for all four quarters $($Safes $[$Totat Sales$1).$ Fill the range P$5$:P$8$ with the fomuld in cell P$4$