Anchoring Entire table rows that are dynamic

[rangerrambo]

I have a table with the following headings

Slot Name 1 2 3 4 5 Total Comment Date

Then i have another table where I am doing some averageifs, I have problem anchoring Table13[Total] so when i drag it, it would stay Table13[Total] across all the cells.

pressing F4 doesnt work

I want

=AVERAGEIFS(Table13[Total],Table13[Name],$B6,Table13[Slot],'Skill (3)'!E$4)

to go to

=AVERAGEIFS(Table13[Total],Table13[Name],$B6,Table13[Slot],'Skill (3)'!F$4)


Instead I get

=AVERAGEIFS(Table13[Comment],Table13[1],$B6,Table13[Name],'Skill (3)'!F$4)



In the next cell I want again

=AVERAGEIFS(Table13[Total],Table13[Name],$B6,Table13[Slot],'Skill (3)'!G$4)

instead of that I get:

=AVERAGEIFS(Table13[Date],Table13[2],$B6,Table13[1],'Skill (3)'!G$4)

Thanks for the help!

 

[rangerrambo]

Is this not possible or was I not clear enough.

Apologies for putting this back on p2.

 

[rangerrambo]

Got lucky and found my answer. Can't do it. But I managed to copy paste and solve my problem.