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

=(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))

answer; fosslls and artifacts;

you go to add your answer type bewteen 5000 and 20 characters and can only have 2 people answer on 1 question.your challanges are based on your questions.