Short Answer 
To calculate total earnings for a branch office, use the SUMIF formula in cell E18. Copy this formula to other cells with the Format Painter, and format the result as currency for better readability.
Step 1: Enter the SUMIF Formula
Start by selecting cell E18, where you want to display the total earnings for a specific branch office. Input the following formula: =SUMIF($D$5:$D$14,C18,$G$5:$G$14). This formula sums the values in the range G5:G14 that match the criteria defined in cell C18, which represents the specific branch office.
Step 2: Copy the Formula Using Format Painter
With cell E18 still highlighted, navigate to the Home tab on the ribbon and click on the Format Painter button. This tool allows you to duplicate the formula from E18 without carrying over any formatting. Drag your cursor to select cells E19:E20 and then release the mouse button to copy the formula into these selected cells, ensuring consistent calculations across multiple branches.
Step 3: Format Cells as Currency
To make the results clearer, select the range E18:E21 where your formulas are located. Then, go to the Home tab on the ribbon and click on the Currency button within the Number group. This action will format the selected cells to display the total earnings as currency, enhancing readability and ensuring that the financial data is presented correctly.