+ Reply to Thread
Results 1 to 4 of 4

countif condition

  1. #1
    Registered User
    Join Date
    05-30-2005
    Posts
    38

    countif condition

    A B
    1 X P
    2 X P
    3 X P
    4 X P
    5 W P


    i want to count WHICH VALUE OF COLUMN A & B = XP
    TOTAL IS 4,

    IN CONCATENATE CONDITION

    YOU USE >>>> =CONCATENATE(A1,B1)
    ANSWER IS "XP"
    THEN YOU USE COUNTIF CONDITION TO GET THE TOTAL OF XP

    HOW CAN USE COUNTIF CONDITION ONLY WITHOUT USING OTHER FORMULA TO
    GET THE TOTAL

    TNX

  2. #2
    Peo Sjoblom
    Guest

    Re: countif condition

    =SUMPRODUCT(--(A1:A5-"X"),--(B1:B5="P"))

    --
    Regards,

    Peo Sjoblom


    "xtrmhyper" <xtrmhyper.1pu22b_1117436701.7338@excelforum-nospam.com> wrote
    in message news:xtrmhyper.1pu22b_1117436701.7338@excelforum-nospam.com...
    >
    > A B
    > 1 X P
    > 2 X P
    > 3 X P
    > 4 X P
    > 5 W P
    >
    >
    > i want to count WHICH VALUE OF COLUMN A & B = XP
    > TOTAL IS 4,
    >
    > IN CONCATENATE CONDITION
    >
    > YOU USE >>>> =CONCATENATE(A1,B1)
    > ANSWER IS "XP"
    > THEN YOU USE COUNTIF CONDITION TO GET THE TOTAL OF XP
    >
    > HOW CAN USE COUNTIF CONDITION ONLY WITHOUT USING OTHER FORMULA TO
    > GET THE TOTAL
    >
    > TNX
    >
    >
    > --
    > xtrmhyper
    > ------------------------------------------------------------------------
    > xtrmhyper's Profile:
    > http://www.excelforum.com/member.php...o&userid=23851
    > View this thread: http://www.excelforum.com/showthread...hreadid=374996
    >



  3. #3
    Registered User
    Join Date
    05-30-2005
    Posts
    38
    how about

    I have column b and column c,

    B C
    1 1
    1 2
    2 1
    2 1



    i wan to count all b=1 with c=1&2

    total count is 2

  4. #4
    Peo Sjoblom
    Guest

    Re: countif condition

    =SUMPRODUCT((A1:A5=1)*(B1:B5={1,2}))

    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "xtrmhyper" <xtrmhyper.1pxdia_1117591501.0019@excelforum-nospam.com> wrote
    in message news:xtrmhyper.1pxdia_1117591501.0019@excelforum-nospam.com...
    >
    > how about
    >
    > I have column b and column c,
    >
    > B C
    > 1 1
    > 1 2
    > 2 1
    > 2 1
    >
    >
    >
    > i wan to count all b=1 with c=1&2
    >
    > total count is 2
    >
    >
    > --
    > xtrmhyper
    > ------------------------------------------------------------------------
    > xtrmhyper's Profile:
    > http://www.excelforum.com/member.php...o&userid=23851
    > View this thread: http://www.excelforum.com/showthread...hreadid=374996
    >



+ 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