Sums of row cells

Closed
Lisa - 3 Oct 2008 à 14:16
 X - 4 Oct 2008 à 19:40
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