Question

In cell K10, create a formula using the SUM function that calculates the total of the range F17:F20, subtracts it from the value in cell J10, adds the total of the range G17:G20, and subtracts 160. I would like to know the correct entry of the formula.

a) =(J10-SUM(F17:F20))+160-G17:G20
b) =(J10-SUM(F17:F20))+G17:G20-160
c) =(J10-SUM(F17:F20))+(160-G17:G20)
d) =(J10-SUM(F17:F20))+(G17:G20-160)

Answer 1

The correct formula to use in cell K10 is =(J10-SUM(F17:F20))+(G17:G20-160). This formula subtracts the total of the range F17:F20 from the value in cell J10, then adds the total of the range G17:G20, and finally subtracts 160.

Step-by-step explanation:

The correct formula to use in cell K10 is =(J10-SUM(F17:F20))+(G17:G20-160).

This formula subtracts the total of the range F17:F20 from the value in cell J10, then adds the total of the range G17:G20, and finally subtracts 160.

Here's how the formula can be broken down:

1. First, we find the sum of the range F17:F20 using the SUM function: SUM(F17:F20).
2. Next, we subtract the result from the value in cell J10: (J10-SUM(F17:F20)).
3. Then, we add the total of the range G17:G20: (J10-SUM(F17:F20))+G17:G20.
4. Finally, we subtract 160: (J10-SUM(F17:F20))+(G17:G20-160).