COUNTIF or something else?
Sorry, It doesn't work.
Hmmm...
how many yes I have in column D and E together,
with the condition that C will be only equal with 1.
......C.....D.....E
1...2......y......y
2...1.............y
3...1......y.....y
4...3..............
5...1......y......
If that's your data what result do you expect?
My interpretation of your post is:
Count how many rows where column C = 1 and *BOTH* column D and column E
contain yes. So, based on that interpretation my formula would return1,
counting only row 3.
Is that what you wanted? If not, a better explanation is needed.
(in case that I have more then 2 columns...)
Exactly how many columns?
--
Biff
Microsoft Excel MVP
"Count-Adi" wrote in message
...
Sorry, It doesn't work. Anything else...(in case that I have more then 2
columns...)
Thanks
"T. Valko" wrote:
Try this...
=SUMPRODUCT(--(C2:C15=1),--((D2:D15="yes")+(E2:E15="yes")=2))
--
Biff
Microsoft Excel MVP
"Count-Adi" wrote in message
...
I am trying to use COUNTIF function where the range might vary. For
instance,
I want to know how many yes I have in column D and E together, with the
condition that C will be only equal with 1.
C D E
1
1 Yes
1 Yes
1
2 Yes
2
2 Yes
3 Yes
3 Yes
3 Yes
3
{=COUNTIF(IF($C$1:$C$11=1,$D$1:$E$11,0),"yes")} should be 2.
Thanks for your help.
.
|