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

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
*

?
*
*?
?

?


*
*
?
*

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

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)


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=525945

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

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


"andre" wrote:

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
*

?
*
*?
?

?


*
*
?
*

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

=SUMPRODUCT(--(LEN(A1:A10)))

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"andre" wrote in message
...
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
*

?
*
*?
?

?


*
*
?
*