=MATCH(A1,{"a","b","c"},0)+MATCH(A2,{"x","y","z"}, 0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kdoggity" wrote in message
...
I'm trying to create a formula that references two cells. In each of the
cells is a drop down box with three options. The options aren't numbers.
Is
there a way to associate values to those options so that the formula will
result in a numerical total?