Solved:
Answered by AI, Verified by Human Experts
Create and copy a SUMIF function to calculate total earnings by branch office. Select cell E18. Start the SUMIF function with cells $D$5:$D$14 as the Range argument. Set the Criteria argument as a relative reference to cell C18. Select cells G5:G14 for the Sum_range argument and make the references absolute. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders. Format cells E18:E21 as Currency
Create and copy a SUMIF function to calculate total earnings by branch office. Select cell E18. Start the SUMIF function with cells $D$5:$D$14 as the Range argument. Set the Criteria argument as a relative reference to cell C18. Select cells G5:G14 for the Sum_range argument and make the references absolute. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders. Format cells E18:E21 as Currency
To create and copy a SUMIF function to calculate total earnings by branch office, follow these steps:Select cell E18.Type the following formula:=SUMIF($D$5:$D$14,C18,$G$5:$G$14)This formula uses the SUMIF function to sum the values in cells G5:G14 that meet the criteria in cell C18, which is the branch office.Press Enter to calculate the result.With cell E18 still selected, click on the Format Painter button in the Home tab of the ribbon.Select cells E19:E20 to copy the formula without formatting.Release the mouse button to copy the formula to the selected cells.Select cells E18:E21.Click on the Currency button in the Number group of the Home tab of the ribbon to format the cells as currency....
Unlock full access for 72 hours, watch your grades skyrocket.
For just $0.99 cents, get access to the powerful quizwhiz chrome extension that automatically solves your homework using AI. Subscription renews at $5.99/week.