HELP! Cell filling by row numbers????

Can you fill a chart across a column but with the row number changing?

Example: Cell A1 =SUM($E10,$E20,$E30) then Cell B1 =SUM($E11,$E21,$E31)

So after i have cell A1 I can drag the fill handle to the right and the number increase but the letter stays?

Thanks

should be able to handle that with index().

something like:

Formula:

=sum(index($E$10:$E$100,column()),index($E$20:$E$100,column()),index($E$30:$E$100,column())

(untested)

i just tested on some bogus data, looks like i forgot one ) at the end...

Formula:

=sum(index($E$10:$E$100,column()),index($E$20:$E$100,column()),index($E$30:$E$100,column()))

if that doesn't work please upload a sample of your data, with an example of your desired result and / or a description of what issue you're having.

Considering your current data setup, you may try something like this in G19.

=IFERROR(SUM(INDEX($C$3:$E$11,MATCH(COLUMNS($G:G),$A$3:$A$11,0),MATCH(RIGHT($F19,1)*1,{1,2,3},0)),INDIRECT(ADDRESS(MAX(INDEX(($A$1:$A$11=COLUMNS($G:G))*(ROW($A$1:$A$11)-ROW($A$1)+1),0)),MATCH($F19,$A$1:$E$1,0)))),"")

and then copy across and down.

***Notice that I have changed the column headers from Gm1 to Game 1 etc.

For detail, see the attached.

sktneer's is probably better since it will switch columns for each new game, but my formula is a little bit simpler (you just have to move the index reference for each new game...

Formula:

=SUM(INDEX($C$3:$C$93,COLUMN()-6),INDEX($C$8:$C$88,COLUMN()-6))

most likely the issue you had stems from the column() reference... since your output is in column G that was returning a 7 instead of a 1.

another way to move the formula automatically w/out messing with indirect:

Formula:

=SUM(INDEX($C$3:$E$93,COLUMN()-6,RIGHT($F19,1)),INDEX($C$8:$E$88,COLUMN()-6,RIGHT($F19,1)))

as in the attached v2... note if you get up to 10 games you'll need to take right($f19,2)...