Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need sum for each row.
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need sum for each row.
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 MVP On Tue, 25 Apr 2006 14:35:03 -0700, Preacher Ted 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|