Reference column question

[Guest]

Setting up a tabulation speadsheet,has 40 rows and 10 columns.Question is
when I do my formula which is a subtraction for each column,I want to use a
refernce # from the first row of each column =Sum(F1-D3)=SUM (G1-D3)and so
to=Sum(P1-D3)Rather than enter each manually,because cut and paste adds 1 to
each column how can I get to use f1 as reference for that column G1 for that
column.Thanx

 

[Guest]

If I understand correctly, try putting a $ in front of the row reference.
Also, sum is not necessary for what you are doing.

=F$1-D3

as you copy that down it becomes
=F$1-D4

copied across to the right it becomes
=G$1-E3


You can fix the row or column or both in this fashion:
F1 (relative row, relatative column)
$F1 (relative row, absolute column)
F$1 (absolute row, relative column)
$F$1 (absolute row, absolute column)