Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Sumif (Excel 2000)

    Hi all,

    i'm working with a Database that I created, in Excel. What I would like to accomplish is to give a value to a cell, based on the conditional value of three different cells, so if A1 = "A" and B1= B and C1=C then D1 = 1, but if it doesn't match any of those it would equal 0. These cell are all offset to one another, and the range will change because I have it so that at the end of every entry into the Database there is a new row, ready for the next input.


    The reason for the value is so that I can graph it.

    Has anyone see a post that might help me get started?

    Thanks,

    Darryl.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sumif (Excel 2000)

    Sorry, could you try to explain that more slowly, with some more examples?

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sumif (Excel 2000)

    How bout this:

    =IF(AND(A1="A",B1="B",C1="C"),1,0)

  4. #4
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Sumif (Excel 2000)

    Thanks For your reply,

    The Formula worked great thank you.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Long Beach, California, USA
    Posts
    233
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sumif (Excel 2000)

    I love this place. I can't count the number of times someone has come thru for me, given me an idea, or posted some code I can tweak.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sumif (Excel 2000)

    I'm sure you meant to thank <!profile=notbrl>notbrl<!/profile>.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Sumif (Excel 2000)

    <hr>How bout this:

    =IF(AND(A1="A",B1="B",C1="C"),1,0) <hr>

    The other approach is:
    = (A1="A") * (B1="B") * (C1="C")

  8. #8
    4 Star Lounger
    Join Date
    May 2004
    Location
    Toronto, Ontario, Canada
    Posts
    425
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Sumif (Excel 2000)

    Thanks kindly for your reply notbrl

    Darryl.

Posting Permissions

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