What is the best way to drag and drop a formula?

[dupp]

Hey there guys,

Right now, I've to do a lot of things manually, taking the formula on the top row copying to the next column on the same row (formula from D3 to E3) and changing the values of the formula and then i have to drag and drop the formula twice (once from C4 and the rest i can select multiple cells from D3 to G3). And I have to make the diagonal line cells blank manually.

I have tried drag and drop the formula to the right (next column), but it does not do it correctly. For example when i try to drag and drop the formula from cell D3 to E3, this formula from cell D3 =IFERROR('Area 2 Data'!D3/('Area 2 Data'!D3+INDEX('Area 2 Data'!$4:$4,1,ROW(3:3))),0)
The $4:$4 does not change to $5:$5
What i want is this formula on cell E3 =IFERROR('Area 2 Data'!E3/('Area 2 Data'!E3+INDEX('Area 2 Data'!$5:$5,1,ROW(3:3))),0)

Check the link below what I am trying to explain. Check for the sheet "Area 2 results".

https://docs.google.com/spreadsheet...ouid=106511416837265576628&rtpof=true&sd=true

So if i have to for example 10 more names, I have to add the formula to 10 more columns and rows. What is the best way to do so with the correct formula and keeping the diagonal line cells blank?

 

[MARK858]

Try...

=IFERROR('Area 2 Data'!D3/('Area 2 Data'!D3+INDEX(OFFSET('Area 2 Data'!$4:$4,COLUMNS($A$1:A$1)-1,),1,ROW(3:3))),0)