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),--(D111="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes"))
>
> Regards,
> Per
>
> "Count-Adi" <Count-(E-Mail Removed)> skrev i meddelelsen
> news:C2B2570B-8263-4955-B5AB-(E-Mail Removed)...
> >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.

=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),--(D111="yes"))+SUMPRODUCT(--(C1:C11=1),--(E1:E11="yes"))
> >
> > Regards,
> > Per
> >
> > "Count-Adi" <Count-(E-Mail Removed)> skrev i meddelelsen
> > news:C2B2570B-8263-4955-B5AB-(E-Mail Removed)...
> > >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.