Question from an not to advance user

A

AUTOCT

Let say that I have collumn A filled with one letter on some line.
How can I add all letter at the bottom, to know how many I have.

And is it also possible to have 2 letter separated by , on the same
line that will also be ad at the bottom.

Thank you
 
P

Pete_UK

Assume your data is in the range from A1 to A99. In cell A100 enter the
formula:

=COUNTA(A1:A99)

This will give you a count of all the non-blank cells in your range.

Pete
 
A

AUTOCT

Can you please rigth down the path to get to that formula
im working on a french version of excel and the formula should b
different.

Thank you for your hel
 
B

Bob Phillips

=NBVAL(A1:A99)

On the second question, use

=SUMPRODUCT(LEN(A1:A99)-(LEN(A1:A99)-LEN(SUBSTITUTE(A1:A99," ",""))))

or

=SOMMEPROD(NBCAR(A1:A99)-(NBCAR(A1:A99)-NBCAR(SUBSTITUE(A1:A99;" "';""))))

in French

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top