Microsoft Office Tutorials and References
In Depth Information
Combine Two Ranges Arithmetically
Chapter 4: Getting More Out of Formulas
The Paste Special dialog
8 Click to select the
arithmetic operation you
want to use.
9 Click OK.
Excel combines the
two ranges using the
If your original data is in a column but your range of factors is in a row, you can still
combine the two ranges arithmetically. (This is also true if your original range is a row
and your factor range is a column.) Follow steps 1 to 7 to open the Paste Special dialog
box and select the arithmetic operation you want to use. Click to select the Transpose
option near the bottom of the Paste Special dialog box, and then click OK.