Add two sets of data

Hi,

Here is an example of the problem I am having on a massive scale. I have two sets of data I want to add together. One is horizontal in cells C1 through Z1, and the other is vertical in cells A3 through A26. Once I get my initial formula in the first destination cell (C1 + A3), is there a way to replicate so that the next cell becomes D1 + A4, then next E1 + A5, and so on? I cannot transpose the data either. Thank you!!!

Dan

You don't specify if "the next cell" is to the right or below (i.e are you dragging down or across)?

If down, then
=INDEX($C$1:$Z$1,ROW(A1))+A3

If across then
=C1+INDEX($A$3:$A$26,COLUMN(A1))
Is that what you are looking for?

Are you copying down?

Is so:

=SUM(INDEX(A:A,ROWS($A$1:$A3)),INDEX($1:$1,ROWS($A$1:$A3)))

Good point Chemist... you don't need the first argument in the SUM to be evaluated... just A3 (if you are copying down)...