Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas Against Columns
Not sure how to enter formulas against columns not cells.
For instance on each row entered want columnD cells to always be the product of columnB cells and columnC cells. Any guidence is much appreciated |
#2
|
|||
|
|||
Hi Gary
you need to put the formula in the first cell in column D e.g. =B1*C1 and fill down (if there's values in C the easiest way to do this is to move your cursor over the bottom right hand corner of D1 until you see a + and then double click). Cheers JulieD "Gary" wrote in message ... Not sure how to enter formulas against columns not cells. For instance on each row entered want columnD cells to always be the product of columnB cells and columnC cells. Any guidence is much appreciated |
#3
|
|||
|
|||
Hi Julie
Thanks for the response. Yes values do exist in C ~ Tryed to move cursor over the bottom right hand corner of D1 until I see a + and then double click however can't get the a + to happen. Am I doing something wrong??? Again thanks a mil for any help Julie -----Original Message----- Hi Gary you need to put the formula in the first cell in column D e.g. =B1*C1 and fill down (if there's values in C the easiest way to do this is to move your cursor over the bottom right hand corner of D1 until you see a + and then double click). Cheers JulieD "Gary" wrote in message ... Not sure how to enter formulas against columns not cells. For instance on each row entered want columnD cells to always be the product of columnB cells and columnC cells. Any guidence is much appreciated . |
#4
|
|||
|
|||
Gary
You must have ToolsOptionsEdit "allow cell drag and drop" enabled(checked) in order to see the + at bottom right corner of the cell. Gord Dibben Excel MVP On Mon, 20 Dec 2004 09:37:46 -0800, "Gary" wrote: Hi Julie Thanks for the response. Yes values do exist in C ~ Tryed to move cursor over the bottom right hand corner of D1 until I see a + and then double click however can't get the a + to happen. Am I doing something wrong??? Again thanks a mil for any help Julie -----Original Message----- Hi Gary you need to put the formula in the first cell in column D e.g. =B1*C1 and fill down (if there's values in C the easiest way to do this is to move your cursor over the bottom right hand corner of D1 until you see a + and then double click). Cheers JulieD "Gary" wrote in message ... Not sure how to enter formulas against columns not cells. For instance on each row entered want columnD cells to always be the product of columnB cells and columnC cells. Any guidence is much appreciated . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |