Worksheet function On the active worksheet enter a formula in cell a1 to return the sum Copy the cell range a2:b8 and paste it to the cell range a1:b7 of the
Copy the cell range A2:B8 and paste it to the cell range A1:B7 of the
A1 cell worksheet active formula cells sum enter


