sum of cells containing text

  • Thread starter Thread starter charlotte
  • Start date Start date
C

charlotte

I have a selection of cells and i need the sum if they contain text anyone no
if this is possible?
 
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 said:
I have a selection of cells and i need the sum
if they contain text
Click to expand...

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)
 
Back
Top