Excel: Dragging Formulas

I am looking to sum two cells on one workbook and then be able to drag the formula down, but the workbook im summing the data from goes across vertically. So when I drag down I get: =A1+A20 =A2+A21 =A3+A22 When what I really want is: =A1+A20 =B1+B20 =C1+C20 Cant figure out how to do this :confused:

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of November 03, 2014.

For more resources for Microsoft Excel