Need sum for each row.

[Preacher Ted]

I have input "Labor", Parts", and "Tax" for each customer. The next column is
"Total". Their must be a way to have the "Total" cell at the and of each row
give you a sum of the amounts in cell "A", "B", and "C" of each row. I know I
can highlight the cells "A", "B" and "C" in any given row and click on the
"sigma" icon and it will add these amounts and place the sum in the "Total"
cell, but there must be a way to set this to happy automatically.

Any help would be appreciated.

Thanks

Ted

[Gord Dibben]

Not automatically but you can, in row 1 drag across columns A, B and C then hit
the sigma as you are doing to get a total in D1.

Now double-click on the the fill handle of D1 to replicate the fomula down
column D as far *** you have data in column C

Or just drag/copy D1 down column D.


Gord Dibben MS Excel MVP


On Tue, 25 Apr 2006 14:35:03 -0700, Preacher Ted
<PreacherTed@discussions.microsoft.com> wrote:

>I have input "Labor", Parts", and "Tax" for each customer. The next column is
>"Total". Their must be a way to have the "Total" cell at the and of each row
>give you a sum of the amounts in cell "A", "B", and "C" of each row. I know I
>can highlight the cells "A", "B" and "C" in any given row and click on the
>"sigma" icon and it will add these amounts and place the sum in the "Total"
>cell, but there must be a way to set this to happy automatically.
>
>Any help would be appreciated.
>
>Thanks
>
>Ted