transpose sum formula

[eing]

I have sum formulas need to be transposed, but I don't know how to do it instantly..
Will somebody help me with this please..?
Here is the sample of the workbook..
please have a look..
Book1.xlsx

I want the result's shows just like the cells marked in yellow..
And I need to know how to transpose the formula more simple..
please..
Thanks for the attention..

[NeedForExcel]

Here!

Select Range A4:E7 & Hit Alt+=

Deep

[eing]

I'm sorry but that's not what I'm trying to do..
I need to do the sum and transpose the formula too..
so the result could be seen just like the yellowed cells..
I hope this will help the explaination..

Well thanks for the feedback..

[FDibbins]

Try this, copied down...
=SUM(OFFSET($A$3,1,ROW(A1)-1,3,1))

[:) Sixthsense :)]

Or

Please Login or Register  to view this content.

[ramananhrm]

Please try this file.

[eing]

So these is the simplest way to do it..
I thought I just need to copy and paste it downward with some button or key..
Alright, I think it already solved then..
Now I just need to choose which help that would be simple for me..
Thank you for your help guys..
I really appreciate it all..