I have done =SUM(F17:F20)-J10+SUM(G17:G20)-160, but it is not matching with the required answer and gave me red checkmark. Help and advice would be appreciated.
Full 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."
Reading books is a great way to learn. Here are some of the books we recommend.
So u made the same mistake that Rames made in this question about subtraction from some cell value.
To solve it u should change urs formula to =J10-SUM(F17:F20)+SUM(G17:G20)-160 because question is instructing to subtract the range F17:F20 FROM J10. So J10 should be at the first.