$($cell $H4)$ using the SUMIF function.

a$.$ The range for the function should reference the "Location" values on the "Transaction Details" table $($range $),$ the criteria should reference the appropriate "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" column.

c$.$ Be careful to use the correct relative and absolute cell references.