Adding an OR

[ddub25]

=IF(B11="Y",COUNTIF(AG11:AR11,"Y")*Z11+COUNTIF(AG11:AR11,"Y2")*(Z11*0.42),0)

Can anyone help with the correct syntax to add an OR into the formula?

I want to this part to be adapted to (AG11:AR11,"Y" OR "SU")

and this part to,

(AG11:AR11,"Y2" OR "SU2").

Thanks.

 

[AlphaFrog]

Try something like this...

=IF(B11="Y",
    (COUNTIF(AG11:AR11,"Y")+COUNTIF(AG11:AR11,"SU"))*Z11+
    (COUNTIF(AG11:AR11,"Y2")+COUNTIF(AG11:AR11,"SU2"))*(Z11*0.42),0)

 

[ddub25]

Thanks very much Alpha, much appreciated.

 

[jasonb75]

You can trim that down a little

=IF(B11="Y",
   SUM(COUNTIF(AG11:AR11,{"Y","SU"}))*Z11+
   SUM(COUNTIF(AG11:AR11,{"Y2","SU2"}))*(Z11*0.42),0)