# countif condition

1. ## 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)
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. ## 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)
> 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
>

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. ## Re: countif condition

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

--
Regards,

Peo Sjoblom

"xtrmhyper" <xtrmhyper.1pxdia_1117591501.0019@excelforum-nospam.com> wrote
in message news:xtrmhyper.1pxdia_1117591501.0019@excelforum-nospam.com...
>
>
> 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
>

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

#### 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