f$.$ Click the Transactions Stats sheet tab and select cell B$7.$

g$.$ Use DSUM from the Database category with the range name Stats as the Database argument.

h$.$ Type $3$ for the Field argument $("$# Transactions" column$),$ and enter an absolute reference to cells $B1$:$B2$ on the Criteria sheet as the Criteria argument. The result is $11555.$ Copy the formula in cell $B7$ to cell $C7.$

j$.$ Edit the Field argument in cell $C7$ to use the fourth column.

$k.$ Use DSUM in cells B$8$:C$9$ to calculate results for the two remaining departments.

$5.$ Calculate totals and ratios.

a$.$ Use SUM in cells B$10$:C$10.$

b$.$ Select and format all values as Comma Style with no decimal places.

C$.$ Select cell D$7$ and enter a forr

Reset Progress $$

d$.$ Format the results as Percent

e$.$ Copy the formula to complete the column and select cell A$5$

Type here to search