countif condition

[xtrmhyper]

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

 

[Peo Sjoblom]

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

 

[xtrmhyper]

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

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)