Problem with autofill incrementing characters when copying

L

Leonid Nikolayev

We are trying to copy(drag it horizontally) the following formula so
that underlined characters ("C") progress in the alphabetical order.
=SUM(INDIRECT("C"& A1)):INDIRECT("C"& A5)))
/\ /\
|| ||
We would like the cell in the next position to the right to have "D"s
in it.
=SUM(INDIRECT("D"& 1)):INDIRECT("D"& 1)))

Is there any way to force Excel increment characters inside of
INDIRECT function in alphbetical order?

Thanks a lot!
 
E

Earl Kiosterud

Leonid,

Since the "C" is in quotes, it's text, not a cell reference. Thus, it
doesn't get adjusted when copying. How about this:

=SUM(OFFSET(C1, A1-1, 0, A5-A1+1, 0))
 
G

Guest

add a helper row and autofill with alpha chars in the
appropriate columns. Ref the helper cell containing
the "A" rather than saying "A" in the expression.

hope this helps
 
Top