countif condition

  • Thread starter Thread starter xtrmhyper
  • Start date Start date
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
 
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)
 
Back
Top