G
GeoffW
On the worksheet cell where you require the result use a
formula such as =SUM(Worksheet1.Cell1,Worksheet2.Cell2,
etc.)
The easiest way is to type in the "=SUM(" and then simply
click on either the individual cells and/or ranges on
each worksheet, with a comma between each, then hit the
Enter key when finished. All of the appropriate cell
references will be inserted correctly.
formula such as =SUM(Worksheet1.Cell1,Worksheet2.Cell2,
etc.)
The easiest way is to type in the "=SUM(" and then simply
click on either the individual cells and/or ranges on
each worksheet, with a comma between each, then hit the
Enter key when finished. All of the appropriate cell
references will be inserted correctly.