summing rows and columns
|
summing rows and columns
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? |
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com