I need to display the sums of rows vertically using ctr+drag for over 80 rows downwards in one column to replicate the formula for the remaining 80 rows, but excel only continues to modify the formala if I drag horizontally.
Here is a small table to demonstrate what I am trying to do.
In cell A12 is the sum of rows A1:F1. I want to be able to display the sums of A2:F2 in cell A13, and A3:F3 in cell A14.
At the moment I can only copy as value, and then transpose. But I don´t want to do this 80 times weekly when I receive this table.
Which formula would enable me to quickly calculate the sums of rows but display them vertically?