Most valuable professional
  • Hot Topics

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 0 0 Cant figure out how to do this

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

This thread is current as of November 3, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel