View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!