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

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

--
Regards,

Peo Sjoblom


"xtrmhyper" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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

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

--
Regards,

Peo Sjoblom

(No private emails please)


"xtrmhyper" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>