if or statement for 2 reference cells resulting in sum of a range

I need help fixing the following formula, I would like to return 0 if ay5 or ay20 is complete otherwise return the sum of aw20:ax20

=IF(OR(AY5="*complete*",AY20="*complete*"),0,SUM(AW20:AX20))

the following formula returns the the sum of aw20:ax20 regardless of whether the formula is true or false.

You need to do it like this:

=IF(OR(COUNTIF(AY5,"*complete*"),COUNTIF(AY20,"*complete*")),0,SUM(AW20:AX20))

as the IF function does not recognise wildcard characters. You could also use ISNUMBER in conjunction with SEARCH (no wildcards needed), or with MATCH (with wildcards).

Hope this helps.

Pete

Thank you so much, that's exactly what I'm looking for =).

Glad to help, Chris - thanks for the rep.

Pete