Number Applying Value To Text Selection In List Box


undefined U N D E F I N E D undefined
I have created a list box where the choice is either I or M. I need the
selection to convert to 0 or 1 accordingly. I then use SUM to add up the
total in a column.
Can anyone help this beginner please?


--
ANDYPAND
------------------------------------------------------------------------
ANDYPAND's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25351
View this thread: http://www.excelforum.com/showthread.php?threadid=388333

.

Relevant Pages

  • how can I multiply 7feet and 6ft 8in?
    ... Please help the beginner. ... epout's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27037 ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Desperate for Help
    ... Keep practising! ... I'm still very much a beginner, but after six months, I can go out with ... totally_hooked's Profile: http://www.unicyclist.com/profile/10069 ... Prev by Date: ...
    (rec.sport.unicycling)
  • Re: Graph with too many points - How to scroll?
    ... One happy beginner today! ... giselle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24222 ... Prev by Date: ...
    (microsoft.public.excel.charting)
  • Re: Conditional Formatting
    ... I want the formatting to work like this: ... ANDYPAND ... ANDYPAND's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25351 ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • If Statements...
    ... I am not quite a beginner, but I'm not an expert either. ... Delaina ... Delaina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24151 ... Prev by Date: ...
    (microsoft.public.excel.misc)
Quantcast