EXCEL 2007

=+COUNTA(M1:M20)

- the above will count non blank cells for the specified range.

If my comments have helped please hit Yes.

Thanks.

"charlotte" wrote:

I have a selection of cells and i need the sum if they contain text anyone no
if this is possible?