software

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= sumTHANK YOU !!!!!!!

emmy--
emmy
------------------------------------------------------------------------
emmy's Profile: www.excelforum.com/member.php...oamp;userid=32700
View this thread: www.excelforum.com/showthread...hreadid=525363In C2, enter =A2 B2
Select C2
Drag down (or copy down)

cell C3 will show =A3 B3

HTH
--
AP

quot;emmyquot; gt; a écrit dans le
message de ...
gt;
gt; when working in a worksheet is it possible to only plug in the formula
gt; once for a selected area, but still recognize that the formula
gt; pertains to each individual row ?
gt;
gt; for example
gt;
gt; A2 B2= sum
gt; A3 B3 = sum
gt; A4 B4= sum
gt;
gt;
gt; THANK YOU !!!!!!!
gt;
gt; emmy
gt;
gt;
gt; --
gt; emmy
gt; ------------------------------------------------------------------------
gt; emmy's Profile:
www.excelforum.com/member.php...oamp;userid=32700
gt; View this thread: www.excelforum.com/showthread...hreadid=525363
gt;