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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sum numbers in cells that also contain text 34
Excel formula, sum the value cell and if empty cell left blank 0
Excel How to add numbers in same cell? 2
Sigma sums 2
Problem with sum across worksheets 2
SUM 3
Need help creating a sum based on variable data. 1
Sum variable range of column entries in offset cell 5

Back
Top