* In a free cell type the value of A4.
* Press CTRL+C for "copy"
* Select the 1095 cells RIGHT(!) click on one of them 'PasteSpecial'
mark 'SUBTRACT' 'O.K.'
That is all
Micky



"Wayne Wells" wrote:

I have 3 years worth of daily data in a spreadsheet. To "normalize" the data,
I am requred to add the first cell value to each of the subsequent cells.
=sumD4-D4 ---This will yield a zero starting point
=sumD5-D4
=SUMD6-D4
=SUMD7-D4
and on and on and on.

I need to subrtact D4 from hundreds of lines of data and there has top be a
better way than doing each one, line by line.