Help to solve this pls. I entered =SUM(D17:D20)-J8, but it is giving in negative.
The full question is "Add formulas to complete the balances section. In cell K8, create a formula using the SUM function that calculates the total of the range D17:D20 and subtracts it from the value in cell J8."
Reading books is a great way to learn. Here are some of the books we recommend.
Your answer is correct but the arrangement is incorrect. The question is saying to subtract the SUM function from J8. So the answer must be =J8-SUM(D17:D20). Thanks.