To carry out simple mathematical calculations, use Paste Special Operation:
1. In this example, assume that columns C and D are sales figures to be added together.
2. Copy column C.
3. Select column D.
4. Press Shift+F10 or right-click, and then select Paste Special from the shortcut menu.
5. In the Operation area, select the Add option button, and then click OK. The figures from column C are added to those in column D.
Screenshot // Adding, Subtracting, Multiplying and Dividing Without Using Formulas