software

I have input quot;Laborquot;, Partsquot;, and quot;Taxquot; for each customer. The next column is
quot;Totalquot;. Their must be a way to have the quot;Totalquot; cell at the and of each row
give you a sum of the amounts in cell quot;Aquot;, quot;Bquot;, and quot;Cquot; of each row. I know I
can highlight the cells quot;Aquot;, quot;Bquot; and quot;Cquot; in any given row and click on the
quot;sigmaquot; icon and it will add these amounts and place the sum in the quot;Totalquot;
cell, but there must be a way to set this to happy automatically.

Any help would be appreciated.

Thanks

Ted

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 ass you have data in column C

Or just drag/copy D1 down column D.Gord Dibben MS Excel MVPOn Tue, 25 Apr 2006 14:35:03 -0700, Preacher Ted
gt; wrote:

gt;I have input quot;Laborquot;, Partsquot;, and quot;Taxquot; for each customer. The next column is
gt;quot;Totalquot;. Their must be a way to have the quot;Totalquot; cell at the and of each row
gt;give you a sum of the amounts in cell quot;Aquot;, quot;Bquot;, and quot;Cquot; of each row. I know I
gt;can highlight the cells quot;Aquot;, quot;Bquot; and quot;Cquot; in any given row and click on the
gt;quot;sigmaquot; icon and it will add these amounts and place the sum in the quot;Totalquot;
gt;cell, but there must be a way to set this to happy automatically.
gt;
gt;Any help would be appreciated.
gt;
gt;Thanks
gt;
gt;Ted