I am required to add two cells together and subtract another in order to get a number.

Example: (D2 + B3) — C3 = D3 (the answer would be put in D3).

The columns are always kept the same, it is just the row number that changes (it adds one each time). Is there any way to do this without using the same formula repeatedly? If there was a way just to change the row number and keep the column the same, that would be ideal. This is my first time using Excel so please bear with me.

New contributor
JoeParker is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

JoeParker is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.