formula question

[Guest]

How can I automatically drag this formula into other columns?
Example: $I$4 1st column
$J$4 2nd column
$K$4 3rd Column
etc, etc........

 

[David Biddulph]

How can I automatically drag this formula into other columns?
Example: $I$4 1st column
$J$4 2nd column
$K$4 3rd Column
etc, etc........

Remove the first $, & use
=I$4

 

[Bob Phillips]

I$4

that is make the column relative, without the $

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)