Can you keep one side of formula from changing while you drag or copy an the second part of formula


Posted by Coney on February 04, 2002 5:34 PM

I have a worksheet in excel in row 1 & 2 the cells in column A & B are blank. In row 3 under column A start a list of names. In row 3 under column B is a list of percentages. In row 1 under column C is a number for a budget. In row 2 unders column C is a formula =sum(c1-the number that is the difference of last years and this years budgets. Now my question is how can I get the formula to run across row 1 under the following columns D,E,F ..... so that the first part of the formula stays =sumB3 and the second part of formula changes to reflect the figure under the new column.
example =sum(B3.C2), next column =sum(B3.D2), next column =sum(B3.E2) and so on with out haveing to change each one after trying to drag the formula or coping across that row.

Posted by Richard S on February 04, 2002 5:52 PM

Look in help and absolute and relative references. If you enter
=SUM($B$3:C3)
and copy as far across as necessary.
Richard



Posted by Derek on February 04, 2002 6:10 PM

Try $B$3 in your formula instead of B3 (NT)