Is there an option where to paste an Autosum?
If I have a horizontal row of figures and I want to know the Average of certain cells, it pastes the result in the next cell along. Sometimes I have a figure in that row and do not want it to be overwritten with the Average.
If it is a vertical column and I want an Average for part of that column, the paste is on the next row down, which changes the figure already there.
I would like to choose where to paste the AutoSum.
Thanks
Pasting Autosum
Re: Pasting Autosum
If you want to display the sum or average of any range in some specific random cell, you can use that specific function in the destination cell like =sum(Range) or average(Range) etc.