Assuming Indian Numerology, the 'D' located in the "2" group is supposed to
be a 'B'. This formula will produce the sum you want (it treats upper and
lower case letters the same)...

=SUMPRODUCT(INT((FIND(MID(UPPER(A1),ROW($1:$999),1 ),
" AIJQYBKR CGLS DMT EHNX UVW FP OZ")-1)/5))

--
Rick (MVP - Excel)


"Venkatesh V" wrote in message
...

HI,

I require a macro / program or excel based tool -- which gives the total
number based on the numbers assigned to each letter.

here are the number assignation to letters.

AIJQY = 1
DKR = 2
CGLS = 3
DMT = 4
EHNX = 5
UVW = 6
FP = 7
OZ = 8

My requirement is -- i have some 50 names.
copy all the names in a column, run macro or function that will
automatically populate the sum of numbers in each letter of the names (in
next column)

i have tried it. but its geting difficult and time consuming. errors are
creeping up for this simpe program!

For example names could be
A Varsha
G Sanya
V Viveka
..
..

so, could you please provide that program.

Thanks & Regards,
Venkatesh