Results 1 to 4 of 4

Thread: Anding (xp)

  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Anding (xp)

    What i want to do is this
    Points Awards
    10 A
    20 B
    30 C
    10 B

    I want to count the number of 10's that are only b's

    Is this possible?

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anding (xp)

    In Outlook?

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Anding (xp)

    Is this an Excel question? You have posted in the Outlook Forum.

    If it is an Excel question, use this array formula adjusted to suit the location of your range, enter it by using "Ctrl-Shift-Enter", which will place it in {} brackets:

    =SUM(($A$3:$A$6=10)*($B$3:$B$6="B"))
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    Toronto, Canada
    Posts
    101
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anding (xp)

    Shoot! In my rushing I did indeed place it into the wrong forum. I'm sorry

Posting Permissions

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