Click Fx (Sum) in cell you desire the answer, Then Click Colum A = A:A or
Row 1 = 1:1 or add rows or columns by Clicking Control + (Column) A,B,C =
A:A,B:B,C:C or Control + (Row) 1,2,3 = 1:1,2:2
Another Method for contunious expanding Columns and Rows
--
William<"M"




"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?
--