Iviio,
Try this:
=SUMPRODUCT(LEN(A1:A10))-SUMPRODUCT((LEN(A1:A10)<LEN(SUBSTITUTE(A1:A10,{"
",0,1,2,3,4,5,6,7,8,9},"")))*(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,{"
",0,1,2,3,4,5,6,7,8,9},""))))
or this
=SUMPRODUCT((LEN(A1:A10)<LEN(SUBSTITUTE(UPPER(A1: A10),{"A","B","C","D","E","F","G","H","I","J","K", "L","M","N","O","P","Q","R","S","T","U","V","W","X ","Y","Z"},"")))*(LEN(A1:A10)-LEN(SUBSTITUTE(UPPER(A1:A10),{"A","B","C","D","E", "F","G","H","I","J","K","L","M","N","O","P","Q","R ","S","T","U","V","W","X","Y","Z"},""))))
Regards,
KL
"Iviio" wrote in message
...
I can use formulas to calculate numbers or figures. How do I sum up letters
in a range of cells?
|