one formula for worksheet
 

when working in a worksheet is it possible to only plug in the formula
once for a selected area, but still recognize that the formula
pertains to each individual row ?

for example

A2+ B2= sum
A3+ B3 = sum
A4 + B4= sum


THANK YOU !!!!!!!

emmy


--
emmy
------------------------------------------------------------------------
emmy's Profile: http://www.excelforum.com/member.php...o&userid=32700
View this thread: http://www.excelforum.com/showthread...hreadid=525363

one formula for worksheet
 

In C2, enter =A2+B2
Select C2
Drag down (or copy down)

cell C3 will show =A3+B3

HTH
--
AP

"emmy" a écrit dans le
message de ...

when working in a worksheet is it possible to only plug in the formula
once for a selected area, but still recognize that the formula
pertains to each individual row ?

for example

A2+ B2= sum
A3+ B3 = sum
A4 + B4= sum


THANK YOU !!!!!!!

emmy


--
emmy
------------------------------------------------------------------------
emmy's Profile:
http://www.excelforum.com/member.php...o&userid=32700
View this thread: http://www.excelforum.com/showthread...hreadid=525363