=SUMPRODUCT((C1:C18=1)*(D1:E18="Yes"))



"Count-Adi" wrote:

Sorry, I have another question. What about having 30 columns from where I
should count these yes- values with the same condition? It will be a long
formula. Is there anything else that might be shorter?

Thanks

"Per Jessen" wrote:

Hi

This should do it:

=SUMPRODUCT(--(C1:C11=1),--(D1:D11="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes"))

Regards,
Per

"Count-Adi" skrev i meddelelsen
...
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.