In cell 07, enter a formula using the SUMIF function that totals the sales for the Destra medical device. Use a range reference to the Device values (range E11:E29) as the range, cell Q6 as the criteria, and a range reference to the Total Sales values (range F11:F29) as the sum_range how to do this in excel

Question

In cell 07, enter a formula using the SUMIF function that totals the sales for the Destra medical device. Use a range reference to the Device values (range E11:E29) as the range, cell Q6 as the criteria, and a range reference to the Total Sales values (range F11:F29) as the sum_range how to do this in excel

Answer 1

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.