Count the letters in the cells and sum in another cell
 

Hy people,

I tried to count the letters in the cells and sum them into another cell.
let me give you an example
Col A Col B Col C D E F
RowA
RowB a b c d e =total letter for the cells
in the left
RowC
D
E

I hope you`ll understand my example and help me with my situation, i olso
try countif, sumif but this are functions for numbers not for letters in
cells.

Thank you!

Count the letters in the cells and sum in another cell
 

If there is at most one letter per cell, then in F1:
=COUNTA(A1:E1)

If there can be more than one letter per cell, then in F1:
=LEN(A1 & B1 & C1 & D1 & E1)

--
Gary''s Student - gsnu200815


"George" wrote:

Hy people,

I tried to count the letters in the cells and sum them into another cell.
let me give you an example
Col A Col B Col C D E F
RowA
RowB a b c d e =total letter for the cells
in the left
RowC
D
E

I hope you`ll understand my example and help me with my situation, i olso
try countif, sumif but this are functions for numbers not for letters in
cells.

Thank you!