Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the number of letters in a cell? | Excel Worksheet Functions | |||
Can i count how many letters A from cell e10 to sell h10 ? | Excel Discussion (Misc queries) | |||
excel: count uppercase letters in a cell | Excel Worksheet Functions | |||
How to count specific letters in range of cells? | Excel Discussion (Misc queries) | |||
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? | Excel Worksheet Functions |