sum of cells containing text

[charlotte]

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

 

[trip_to_tokyo]

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.

 

[Joe User]

I have a selection of cells and i need the sum
if they contain text

Do you mean count, not sum? Do you mean count all cells even if they
contain text; or do you mean count the cells that contain text, excluding
those that are numeric?

To count all non-empty cells:

=counta(A1:A100)

To count cells that contain text, exlcuding those that are numeric:

=sumproduct(--istext(A1:A100))

To sum cells, regardless of whether they are numeric or they contain numeric
strings as text:

=sumproduct(--A1:A100)

 

[ozgrid.com]

SUMIF?
http://www.ozgrid.com/Excel/sum-if.htm