Perhaps I have not expressed my idea in the right way:
By saying equal one of the 10 values, I means:

Sum if (Ai="Value1") and (Bi =any in {Value2,Value3,Value4,....})

with Value2,Value3,Value4,.... is given through a range
thanks for prompt reply