how can i make excel sum up the number of letters i have in a row?

A

andre

if my culomn looks like that and i want to know how many ? and * i have the
culomn how do i make it happen? sometimes i have 2 symbols in the same cell.
thank you so much
*

?
*
*?
?

?


*
*
?
*
 
C

CaptainQuattro

The easiest way to calculate the number of characters in the column
would be to use an adjacent cell to calculate the length of the string
in each cell of your column, and then sum the results, as follows

A _____ B

* _____ =LEN(A2) {result would be 1}
*? _____ =LEN(A3) {result would be 2}


=SUM(B1:B100)
 
R

Ron Coderre

Try something like this:

For a list of values in A1:A110
and a character to find in B1

C1:
=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(UPPER(A1:A10),UPPER(B1),"")))/LEN(B1)

If B1: ?
C1 will return the count of question marks in A1:A10 (even if there is more
than one in a cell)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top