+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Return value if four criteria are met

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2007
    Posts
    18

    Return value if four criteria are met

    Put value in B16 if four criteria in the range Y7:BO20 are met
    • County A
    • d related
    • l
    • January-12

    I copied the formula from B9 and pasted it in B16, changed +B21 to +B22 and got an incorrect result.

    Any suggestions?

    Catherine
    Attached Files Attached Files
    Catherine

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Return value if four criteria are met

    Hi Catherine,

    What is the result you're expecting?

    S.

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Return value if four criteria are met

    What should the answer be? 67?
    Sincerely
    Søren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  4. #4
    Registered User
    Join Date
    04-16-2012
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return value if four criteria are met

    I'm expecting 21, the contents of cell Z16.

  5. #5
    Registered User
    Join Date
    04-16-2012
    Location
    Baltimore, MD
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Return value if four criteria are met

    This formula worked in B16:

    =SUMPRODUCT(--($Z$7:$BO$7=$B$7),--($Z$8:$BO$8=B$8),($Z$15:$BO$15))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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