View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Need to give a letter a value and sum

Hi,

It may be me, but I don't understand what you want. Could you try to
explain this again.

--
Thanks,
Shane Devenshire


"JC-PS" wrote:

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.