+ Reply to Thread
Results 1 to 2 of 2

one formula for worksheet

  1. #1
    Registered User
    Join Date
    03-22-2006
    Posts
    2

    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

  2. #2
    Ardus Petus
    Guest

    Re: 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" <[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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1