how to autofill horizontal formula vertically?

[emiel_inter]

I created a simple sum formula, in which the rows remain the same, but the columns move one place to the right. (so first the formula is SUM(E37+E53+E54+E55+E56), and then it becomes SUM(F37+F53+F54+F55+F56) and this process is repeated a lot of time.)


I tried to do this with autofill but I don’t know how I would get the results shown in a vertical way above each other?

Can somebody help me?

Emiel

 

[sergioMabres]

Hi Emiel,
What is your question?
If you do not know how to anchor addresses ($A$1, $A1, A$1 and A1 using F4) for copying and pasting please read about it at http://www.exceluser.com/excel_help/questions/cellrefs.htm
If you are familiar with it, I am sorry to bring it up.
Cheers
Sergio