Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
To Bob(regarding drop downs)- Pls reply
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
.... or more simply
=SUMPRODUCT(((B2:B100={"L","M","H"})*{1,2,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refer to seperate workbook for validation list for drop downs? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Drop Downs Menus | Excel Worksheet Functions | |||
Filling drop down box | Excel Discussion (Misc queries) | |||
Drop List Referencing | Excel Worksheet Functions |