Hi. I have inserted drop downs in a worksheet. The
contents of the drop down is 'L', 'M' and 'H'. I am going
to send my spreadsheet out to ppl to fill in the data by
selecting the appropriate state- L,M or H. What I want to
do is be able to add the cells of one row ie; allocate
numbers 1,2 and 3 to L,M, and H and get a score for each
row. Can anyone help me with this???