Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel template automatic calculates
Hello
i downloaded a template from excel that automatically calculates the totals in each row and the last colum. i would like to add a column and also have it calculate but i don't know how. ex. column a+b do not calculate but column c,d,and e do calculate I would like to make column be calculate. I'm not sure if i explained this right,but any help will be appreciayed Thanks Bobby |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel template automatic calculates
Hi
Your first sum formula in column F should look like this: =SUM(C1:E1) change C to B: =SUM(B1:E1) and copy down or double click on the small black cross in the bottom right corner of the cell. Hope this helps! Jean-Guy "bobby02169" wrote: Hello i downloaded a template from excel that automatically calculates the totals in each row and the last colum. i would like to add a column and also have it calculate but i don't know how. ex. column a+b do not calculate but column c,d,and e do calculate I would like to make column be calculate. I'm not sure if i explained this right,but any help will be appreciayed Thanks Bobby |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel template automatic calculates
If you posted the URL for the Template I could download it and have a look.
Also post a bit more info on where you are adding the column. Gord Dibben MS Excel MVP On Mon, 1 Jan 2007 17:34:00 -0800, bobby02169 wrote: Hello i downloaded a template from excel that automatically calculates the totals in each row and the last colum. i would like to add a column and also have it calculate but i don't know how. ex. column a+b do not calculate but column c,d,and e do calculate I would like to make column be calculate. I'm not sure if i explained this right,but any help will be appreciayed Thanks Bobby |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel template automatic calculates
Hi Gord,
here is the link for the template i am talking about. What i would like to do is add 2 columns before hours,1 for material and 1 for price, and have it automatically put the total in the amount column. for example 2 (in material column) $15.00 (in price column) and automatically put $30.00 (in the amount column). i hope i explained that good enough for you. Thanks again. "Gord Dibben" wrote: If you posted the URL for the Template I could download it and have a look. Also post a bit more info on where you are adding the column. Gord Dibben MS Excel MVP On Mon, 1 Jan 2007 17:34:00 -0800, bobby02169 wrote: Hello i downloaded a template from excel that automatically calculates the totals in each row and the last colum. i would like to add a column and also have it calculate but i don't know how. ex. column a+b do not calculate but column c,d,and e do calculate I would like to make column be calculate. I'm not sure if i explained this right,but any help will be appreciayed Thanks Bobby |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel template automatic calculates
Bobby
You have not included the URL so I'll make a guess. Insert two new columns...... ..material and price, say columns D and E In the amount column enter =D2 * E2 and copy down. If you don't want a 0 showing for nothing entered in D or E enter this =IF(OR(D2="",E2=""),"",D2*E2) Gord On Mon, 1 Jan 2007 19:24:19 -0800, bobby02169 wrote: Hi Gord, here is the link for the template i am talking about. What i would like to do is add 2 columns before hours,1 for material and 1 for price, and have it automatically put the total in the amount column. for example 2 (in material column) $15.00 (in price column) and automatically put $30.00 (in the amount column). i hope i explained that good enough for you. Thanks again. "Gord Dibben" wrote: If you posted the URL for the Template I could download it and have a look. Also post a bit more info on where you are adding the column. Gord Dibben MS Excel MVP On Mon, 1 Jan 2007 17:34:00 -0800, bobby02169 wrote: Hello i downloaded a template from excel that automatically calculates the totals in each row and the last colum. i would like to add a column and also have it calculate but i don't know how. ex. column a+b do not calculate but column c,d,and e do calculate I would like to make column be calculate. I'm not sure if i explained this right,but any help will be appreciayed Thanks Bobby |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove the annoying automatic date formatting in Excel? | Excel Discussion (Misc queries) | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
enable automatic refresh | Excel Worksheet Functions | |||
excel template wizard | Excel Discussion (Misc queries) | |||
I get a program error when I download an excel template | Excel Discussion (Misc queries) |