need help with formula when dragging down

p45cal · #1 03-05-2019, 03:14 PM

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 · #2 03-06-2019, 07:46 AM

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.

p45cal · #3 03-06-2019, 01:33 PM

Quote:

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))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dragging a row changes formatting	BertLady	Word Tables	1	12-01-2018 11:44 PM
Dragging conditional formatting like a formula	sjp1966	Excel	9	04-13-2017 06:01 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Dragging cells with filters on	krisjah	Excel	1	01-25-2014 11:08 AM
Dragging Pictures into Placeholders	simville02	Drawing and Graphics	1	09-29-2013 06:33 PM