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
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
In C2, enter =A2+B2
Select C2
Drag down (or copy down)
cell C3 will show =A3+B3
HTH
--
AP
"emmy" <[email protected]> a écrit dans le
message de news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks