sum of cells containing text
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?
|