$1\mathrm{.}2$ Calculate "Total Sales" $($cell $H4)$ using the SUMIF function.

a$.$ The range for the function should reference the "Location" values on the "Transaction Details" tab$]($range C$4$:C$68),$ the criteria should reference the appropri$$te "Location" value on the "Sales Summary" table $($cell $($F$4),$ and the sum$\_$range should reference the "Sale Amount" values on the "Transaction Details" table $($range

b$.$ Copy your formula down to complete the "Total Sales"