+ Reply to Thread
Results 1 to 11 of 11

Only count when there is 1 of 3 criterias met.

Hybrid View

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Only count when there is 1 of 3 criterias met.

    Hey.

    How do I get A1 to count whenever cell A2 has an A, B or C?

    Thank you.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Only count when there is 1 of 3 criterias met.

    Maybe

    =--OR(A2="A",A2="B",A2="C")
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert Kevin UK's Avatar
    Join Date
    12-07-2010
    Location
    Radstock, Somerset
    MS-Off Ver
    365
    Posts
    1,922

    Re: Only count when there is 1 of 3 criterias met.

    Hi DugiDug

    Not sure what you mean by count, this will give a true if A1= A, B or C:
    =OR(A1={"A","B","C"})
    Regards Kevin


    Merged Cells (They are the work of the devil!!!)

  4. #4
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Only count when there is 1 of 3 criterias met.

    Dosn't work: :S

    I need it to count 1 as soon as there is an A, B or C in A2:A10?

  5. #5
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Only count when there is 1 of 3 criterias met.

    OK.

    A little more advanced now:

    In D1 I wont to count 1, whenever A1:A10 has a D and whenever B1:B10 has either an "A", "B" or "C".

    So D1 will show "1", when A1 has "D" and B1 has "B".

    And D1 will show "2", when A1 has "D" and B1 has "B" + A3 has "D" and B3 has "C".

    How will this look?

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Only count when there is 1 of 3 criterias met.

    =SUMPRODUCT((A1:A10="d")*(B1:B10={"a";"b";"c"}))

    Change the semi colons to comma if you have to do this.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  7. #7
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Only count when there is 1 of 3 criterias met.

    Dosn't work. :S

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Only count when there is 1 of 3 criterias met.

    Works. ......................

  9. #9
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Only count when there is 1 of 3 criterias met.

    It gives me: "?NAME#" when I try that.

  10. #10
    Registered User
    Join Date
    02-27-2013
    Location
    Koege, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Only count when there is 1 of 3 criterias met.

    Fixed that, now it shows "#I/T". :S

  11. #11
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Only count when there is 1 of 3 criterias met.

    ....................................
    Attached Files Attached Files

+ 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