Apr 02 2021 04:15 PM
I am trying to add dollar values from cells on different work sheets to a master worksheet. For example, I want to add C10 on worksheet 1 to B12 on worksheet 2 and have the result post on D4 on worksheet 3. Thanks.
Apr 02 2021 09:53 PM
@jcmforyoujohn That would be
=Sheet1!C10+Sheet2!B12
or, in case the sheet names contain spaces:
='Sheet 1'!C10+'Sheet 2'!B12
Note the apostrophes surrounding the sheet name.