Count the letters in the cells and sum in another cell

G

George

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!
 
G

Gary''s Student

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top