when you copy a cell that shows the autosum, you are actually copying the formula, NOT the sum. so you can copy the cell which has your sum, and then paste it into all the cells you want to add. Hope that helps