+ Reply to Thread
Results 1 to 3 of 3

Formula for pulling column I ttl in column I for each "e" row that

  1. #1
    Cheryl B
    Guest

    Formula for pulling column I ttl in column I for each "e" row that

    a b c d e f
    g h i
    5/15/2004 2585 SCHMIDT, PLUMBING R N 484.00 85.25 10 ????

    I need to have column "I" be the sum of column G if column e = N.
    The last solution I received from Andy B didn't work as it just brought the
    column
    name over.
    Help please!


  2. #2
    Bob Phillips
    Guest

    Re: Formula for pulling column I ttl in column I for each "e" row that

    =IF(E2="N",G2,"")

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Cheryl B" <Cheryl [email protected]> wrote in message
    news:[email protected]...
    > a b c d e f
    > g h i
    > 5/15/2004 2585 SCHMIDT, PLUMBING R N 484.00 85.25 10 ????
    >
    > I need to have column "I" be the sum of column G if column e = N.
    > The last solution I received from Andy B didn't work as it just brought

    the
    > column
    > name over.
    > Help please!
    >




  3. #3
    Peo Sjoblom
    Guest

    RE: Formula for pulling column I ttl in column I for each "e" row that

    =SUMIF(E:E,"N",G:G)


    Regards,

    Peo Sjoblom

    "Cheryl B" wrote:

    > a b c d e f
    > g h i
    > 5/15/2004 2585 SCHMIDT, PLUMBING R N 484.00 85.25 10 ????
    >
    > I need to have column "I" be the sum of column G if column e = N.
    > The last solution I received from Andy B didn't work as it just brought the
    > column
    > name over.
    > Help please!
    >


+ 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