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???

=SUM(LOOKUP(A2:M2,{"H",3;"L",1;"M",2}))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dharsh" wrote in message
...
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???

Thanks sooooo much for the prompt reply Bob.
I am not sure how I'd modify this to apply it to my
spread sheet.I'd really appreciate it if you could reply
to this one as well.

Say in Column B i have a couple of L and a couple of Ms
(first 4 rows). So when I add it up , it should give me
(1+1+2+2)=6. How will I change the equation you just gave
me to apply it to this column and rows?


-----Original Message-----
=SUM(LOOKUP(A2:M2,{"H",3;"L",1;"M",2}))

which is an array formula, so commit with Ctrl-Shift-
Enter, not just Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dharsh" wrote in message
...
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???


.