Here is one way for B2:B100, use
=SUMPRODUCT(((B2:B100="L")*1)+(B2:B100="M")*2+(B2: B100="H")*3)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dharsh" wrote in message
...
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?
Thanks in anticipation
|