countif condition

X

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
 
X

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
 
P

Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top