Question from an not to advance user

[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

 

[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

 

[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

 

[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)