imposible condition?

  • Thread starter Thread starter xtrmhyper
  • Start date Start date
X

xtrmhyper

cell range condition

--A---B---C---D---
1 X P
2 X P
3 X P
4 X D
5 X E

I WANT TO COUNT A=X AND B=P&E
TOTAL IS 4

ANOTHER QUESTION IS>>> THE RANGE ON THAT CONDITION
IS A1:A5,BA:B5

i want what happen is if you type in column c=1 & d=3
the range of A1:A5,BA:B5
WILL A1:A3,B1:B3, RANGE WILL BE INCREMENT OR DECREMENT


TNX

AGAIN

GODSPEED:
 
=SUMPRODUCT((A1:A1000="X")*(B1:B1000={"P","E"}))

and then

=SUMPRODUCT((INDIRECT("A"&C1&":A"&D1)="X")*(INDIRECT("B"&C1&":B"&D1)={"P","E
"}))
 
Use the following Array formula:-

=SUMPRODUCT((A1:A5="X")*(B1:B5="P"))+SUMPRODUCT((A1:A5="X")*(B1:B5="E"))

Not sure what you mean on the second part of your question
 
Back
Top