Thanks Morrigan, your formula is exactly what I am looking for.

Michael wrote:
Could you give a little more information - what are you trying to accomplish?
What are the formulas?
--
Sincerely, Michael Colvin


"snax500" wrote:

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks