MyEducator Tasks

$1\mathrm{.}1$ Calculate $"$# of

Transactions" $($cell G$4)$ using the COUNTIF function.

a$.$ The range for the function should reference the "Location" values on the "Transaction Details" table $($range and the criteria should reference the appropriate "Location" value on the "Sales Summary" table $($cell F$4).$

b$.$ Copy your formula down to complete the $"$# of Transactions" column.

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