Amendment to a Data Validation formula

[Pauljj]

I am using a formula in a Data validation as follows

=(E10="YES")*COUNTIF($E$10:$I$10),"YES")<3


This is looking at a row in columns E to I for the word YES and only allowing the word to appear 3 times.

If I want to change this to allow the word training as well, how could I do this please ??

Cheers

Paul

 

[Pauljj]

Many thanks works perfectly