I have a spreadsheet with a column that contains a (single) changable $
amount. In another column I have cells with different $ numbers in each
cell. In a third column I want the sum of the changable # amount plus the
amount in each cell to reflect in the third column in each individual cell.

If I copy the formula, it changes the cell number from the first column.

Essentially what I want to do is enter one number and change an entire
range of totals by adding cell 1 to cell 2 to display in cell 3. But without
manually doing this I haven't been able to figure out how to construct the
formula.

How can I write this formula.....or maybe the better question is, CAN I
write a formula that will do this?
--
CLJ