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
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