

You may want to do some math only with selected cells in the active worksheet The Cell's math with selected cells tool does it for you. 

2. Select the mathematical operation you want to perform. 3. Now you can set the way results will be displayed: either as formulas or just as values, or maybe as a link to those cells (this latest option is available only if you choose one cell in each sheet) 4. Choose the destination cell for results (as shown in the figure above) That would be it. As results were pasted as formulas, the result will look like this: 
