1 answer
(click or scroll down)
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.