Share via

COUNTA TEXT Exclude cell with formulas or errors

Anonymous
2011-12-10T21:44:22+00:00

I am counting a range of cells contain TEXT. This is derived from a formula which includes IFERROPR. I want to modify CONTA to only count cells containing text, exclude cells containing formulas.

Thank you

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-12-10T21:54:40+00:00

I am counting a range of cells contain TEXT. This is derived from a formula which includes IFERROPR. I want to modify CONTA to only count cells containing text, exclude cells containing formulas.

Some clarification may in order. Do you mean that you want to count the cells containing text and the cells with formulas that are returning text but you do not want to count the cells with formulas that are returning blank cells, e.g. ""? If this is correct, try,

=SUMPRODUCT(ISTEXT(A1:A9)*(A1:A9<>""))

Was this answer helpful?

7 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-12-10T22:18:06+00:00

    Thanks, does the trick...

    Phil

    Was this answer helpful?

    0 comments