View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JC-PS JC-PS is offline
external usenet poster
 
Posts: 29
Default Need to give a letter a value and sum

I need to give at the end of a row, a total of a particular value, say 7.5,
to various letter like W or L, S ,O, etc ---some 10 letters--or sum an
alphanumerical one.

1.....A.....B.....C.....D.....E.................J
2.....L......W.................................... ...7.5

Column J should keep just those letters, eg. W, on row #2, and change it to
7.5. But if column B (with the W letter) should have a number aside, eg.
W3.5 or other,
must be keep this value instead of 7.5.on J.

I've been looking for some answer in this forum but not a clue at present.
Any help, could be helpful.