I believe my explination must be wrong. May I pose a new scenario to
make it easier for me?
A1=10
B1=10
C1=10
D1=10
E1=40 (sum of A1

1)
I want to input a formula into A2 that I can drag down to A6 and auto
fill the results. So, the results would be:
A2=10
A3=10
A4=10
A5=10
A6=40
It is basically taking a L-R and converting it to Top-Bottom. If you
can tell me which formula I enter into A2 that I can drag down to A6
and accomplish the above result, that would be great.
Thanks everyone for your help with this.
John
Myrna Larson <
[email protected]> wrote in message
If you meant [cells] A1 to Z1 rather than A1:A26, in A100 use this formula:
=OFFSET($A$1,0,ROW()-100)
Or you could select cells A100:A125 and enter this array formula:
=TRANSPOSE($A$1:$Z$1)
enter the above with CTRL+SHIFT+ENTER.
Can I use Absolute Values in a row to reference cells in a column?
Example:
I want cells A100 to A126 to reference columns A1 to to A26 by using
Absolute Values and auto filling the column. So...
A100 = A1
A101 = B1
A102 = C1