To sum a row =SUM(A1:M1)

To sum a column =SUM(A1:A20)

To sum everything =SUM(A1:M20)

As far as "saving" to the next worksheet, just hit F2 and add an apostrophe
before the formula.

Copy and paste to the next worksheet....remove the apsostrphes from both cells.


Gord Dibben MS Excel MVP


On Fri, 13 Apr 2007 14:58:03 -0700, RKS wrote:

How do I sum rows and and columns to the total of the row and column at the
same time? Then how do I save that formula to the next worksheet?