Adding cells from different work sheets.

Occasional Visitor

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.

1 Reply

@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.