Create and copy a SUMIF function to calculate total earnings by branch office.

Select cell E$18.$

Start the SUMIF function with cells $D$$5$:$D$$14$ as the Range argument.

Set the Criteria argument as a relative reference to cell C$18.$

Determine the Sum$\_$range argument and make the references absolute$.$

Copy the formula in cell E$18$ to cells E$19$:E$20$ without formatting to preserve borders.

Format cells E$18$:E$21$ as Currency with zero decimal places.

Total the earnings in cell E$21.$

Calculate the average, mode, and median values in cells E$22,$ E$23,$ and E$24$ for the commission and bonus totals in column G$.$

Correct border and number format inconsistencies as needed.