THanks, however, I am not sure how to use that formula. I copied it, but I
think there should be something in the second brackets??

Ok..here is a "graphic" representation of my problem:

A B C D E F G H I J
1
2
etc
48
49 totals....................

Now I want the totals from Row 49 to be like this (below it in the same
worksheet)

=A49
=B49
=C49
etc
=BZ49

There are too many for me to enter manually, one by one. If I did, I would
have to click on the cell where I want the total brought down, hit = then
click on the cell with the total in row 49. That's just not possible.

If I put in =A49 in the first row, and highlight, and fill down, it goes
like this

=A49
=A50
=A51

When I use =OFFSET(C$49,0,ROW()-50), it just copies the same thing..no
changes.





"David Biddulph" wrote:

"Rachael" wrote in message
...
Anyone know how to do this? Here is what I mean:

I have about 40 columns across the page that will have data summed up in
row
49. I need the totals in row 49 put into a separate chart for
calculations.
(i.e. Column C will have numbers in 1-48 totaled in row 49. Same thing for
all columns from C to BZ)

I want to add the column letters, not the numbers, and that is where I
have
the problem.

I have the fomula to read "=C49", so that my total in C49 is pulled to
where
I want it for further calculations. Then in the next row below needs to
read
"=D49" and then "=E49" and so on, so that all the column totals are now in
one column from top to bottom. How do I get fill down/fill series to add
the
column letters? When I use fill down, it starts going C49, then C50, then
C51, which is NOT what i want it to do. I need it to read =C49, the D49,
ext
to BZ49.

I also have a more complex formula "=ROUND(C49*C5*24,2)", which will be
using the totals I have moved over, and when I use fill down with it, it
adds
the numbers as well, so it goes to "=ROUND(C50*C6*24,2)" instead of
"=ROUND(D49*D6*24,2)".

How do get the letters to "increase" but not the numbers? I suspect I will
have to put a $ in front of the numbers, but I have no idea what to do
with
the letters.
Any ideas?

If your reference to C49 is going in C50, then try
=OFFSET(C$49,0,ROW()-50) and copy down from there

The same technique will work for your other formula.
--
David Biddulph