Forum Discussion
Excel Help for fairly new user
I am working on an older worksheet from a excel document some else created that has multiple pages. I have saved this as a new document for me to make changes since this is a new job from the origin...
I think it might help if you know the elements of the formula used:
=+B6+(@'Dec 14-20'!D6:E6)
translates to
"Add the cell B6 in this worksheet to cells D6 through E6 on the sheet 'Dec 14-20'"
You can change that formula manually, or you can click in the total cell, type:
+
click B6
type +
click the cell in the other sheet to add to.
Hope that's clear 🙂
To c