Sums of row cells

Closed
Lisa - Oct 3, 2008 at 02:16 PM
 X - Oct 4, 2008 at 07:40 PM
Hello,
I use an excel spreadsheet for bookkeeping purposes for a single person corporation. I want to total amounts across each row. In other words the last cell of row one contains the sum of columns c1 to t1; the last cell of row 2 contains the sum of columns c2 to t2 and so on down the sheet. Can I tell Excel to perform this function for each row in this last cell ( it is always column U), once, and not every single time?

1 response

Just enter the formula (=SUM(C1:T1)) in U1. Then Copy U1 to U2:Ux
0