need help with formula when dragging down

[JVenz0913]

I want to have the cell reference change when I copy it down I am working out of Excel Office 365

This is the formula in the cell
=SUM('Annual Invoice Breakdown'!D35)

The next formula I want to read
=SUM('Annual Invoice Breakdown'!E3:E5)

Thank you kindly!

[p45cal]

you could try something along the lines of:
=SUM(INDEX($D$3:$Z$5,0,ROW()-13))
but the 13 in there is because the topmost cell my formula was in was on row 14.
You need to adjust the 13 to the row the topmost formula is in minus 1, then copy down.

[JVenz0913]

The data I am trying to pull is on another sheet within the same book. I just need the Letter of the column to change once i copy and paste the formula down.

[bosco_yip]

Try….........................

=SUM(INDEX('Annual Invoice Breakdown'!$D$3:$Z$5,0,ROWS($1:1)))

or,

=SUM(OFFSET('Annual Invoice Breakdown'!D$3,0,ROWS($1:1)-1,3))

Copied down

Regards
Bosco

[p45cal]

Originally Posted by JVenz0913

The data I am trying to pull is on another sheet within the same book. I just need the Letter of the column to change once i copy and paste the formula down.

Ah yes, I forgot the sheet ref:
=SUM(INDEX('Annual Invoice Breakdown'!$D$3:$Z$5,0,ROW()-13))