Dragging down by Column rather than row

[Excel_77]

Hi All,

I tried a similar question on Friday and worded it badly so hopefully this will explain better today.

I have a two tab spreadsheet and on tab2 I want to complete some calculations.

In cell C1 of "tab2" I want to return the total from column BA of "tab1", the length of BA is from BA4 - BA33726. Problems arise however as I want to drag this formula down to cell C40, however within cell C2 I want the contents from BB and so on, how is this possible?

Thanks

 

[ukmikeb]

Hi

@Joe4 has answered your query in post #4 of this :-
http://www.mrexcel.com/forum/excel-questions/978983-dragging-formula.html
thread.

It is just that the references to each column are relative rather than absolute.

Have you tried his suggested solution?

 

[gaz_chops]

Duplicate Post