Forum Discussion
Updating a cell on a different worksheet
It's been a while since I've used Excel. A number of new things since then, and I'm having trouble with a formula. Any assistance would be greatly appreciated as I'm not finding an answer in the Help...
A formula on one sheet cannot directly set the value of another cell.
General!B7=General!B7+D3 does not assign a new value to General!B7. It is a comparison that returns TRUE or FALSE - in this case FALSE since D3 is not zero.
Do the following instead:
I assume that A7 on the General sheet contains Bank Merchant Fee. If not, enter it there.
In B7 on the General sheet, enter the formula
=SUMIFS('Check Book'!$D:$D, 'Check Book'!$C:$C, A7)
Replace Check Book with the real name of the sheet where you enter the categories and amounts.
If you have other categories in column A of the General sheet, you can copy/paste the above formula, or fill it down.
- Thank you, Hans. I assumed that since you can pull data from a cell on a different sheet, that you could also put data into a different sheet. I will try this.
