Question

In cell K8, create a formula using the SUM function that calculates the total of range D17:D20 and subtracts it from the value in J8

Answer 1

Answer:

=(J8 - SUM(D17:D20))

Explanation:

Required

Add D17 to D20

Subtract the result from J8

Save the result in K8

To do this, we make use of a nested bracket.

The innermost bracket is to add up D17 To D20 using the sum function.

i.e. SUM(D17:D20)

While the outermost bracket will subtract the calculated sum from J8.

=(J8 - SUM(D17:D20))