In cell F18, enter a formula using the DSUM function to total bonuses paid to employees with a performance rating of 3. Use the table range A3:F16 as the database argument, the Bonus column heading in cell F3 as the field argument, and range D3:D4 as the criteria. How to do in excel

To achieve this in Excel, you can follow these steps:

1. Select cell F18 where you want the total bonuses to be displayed.

2. Enter the following formula:
`=DSUM(A3:F16, "Bonus", D3:D4)`

This formula uses the DSUM function to calculate the sum of bonuses paid to employees with a performance rating of 3. The database argument is the range A3:F16, the field argument is "Bonus" (which refers to the Bonus column heading in cell F3), and the criteria range is D3:D4 which contains the criteria of a performance rating of 3.

3. Press Enter to apply the formula and calculate the total bonuses paid to employees with a performance rating of 3.

You should now see the total sum of bonuses paid to employees with a performance rating of 3 in cell F18.