Formula with row()

[xiluan]

I'm pretty new with Excel.
I'm working on a formula.
For example: I add "=A1+B1" into cell C1
and "=A2+B2" into cell C2
and "=A3+B3" into cell C3
and so on.....

I want something like "=ARowNum+BRowNum" into CRownum
So for each row in C column, I can put in same Formula and
the value is returned according to that row number.

 

[Frank Kabel]

Hi
just enter
=A1+B1
in cell C1
and copy/drag this formula down. The row index will change
automatically. you may have a look at
http://www.cpearson.com/excel/relative.htm
for explaining this

 

[Bob Phillips]

=INDIRECT("A"&ROW())+INDIRECT("B"&ROW())

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi!

And for a quick way:

In C1 enter
=A1+B1
Then select C1
Point to bottom right corner of the cell until you see the + (drag
handle)
Double click

This copies down until the last adjacent empty cell.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

Thanks a lot!

-----Original Message-----
=INDIRECT("A"&ROW())+INDIRECT("B"&ROW())

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.