Forum Discussion
Transposing Absolute References
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums...
Are you absolutely wedded to the idea of dragging single-cell formulas based upon the concept of relative referencing? If the objective is simply to get a result, array formulas would provide the result you describe. Using 365
= TOROW(BYROW(array, SUM))Using older generations of Excel
= TRANSPOSE(MMULT(array, {1;1;1;1;1}))entered with CSE would give a result for a 5-column array.
- Thanks, Peter! I love learning new Excel tricks.
