1 answer
(click or scroll down)
To achieve this in Excel, follow these steps:
1. Click on cell G7 to select it.
2. Input the following formula: =SUMIF(E11:E29, Q6, F11:F29)
3. Press Enter.
This formula will calculate the total sales for the Destra medical device by summing up the values in the Total Sales range (F11:F29) where the corresponding values in the Device range (E11:E29) match the criteria specified in cell Q6.