Count D3:D154 = Text

[marine_hm]

I'm trying to count a column with specific words such as due, overdue, missed... Whatever! And not count the cells with numbers in them.

I'm thinking Excell would be able to handle that.

Thank you all so much!

SOLVED! Thanks Pete_UK

[Pete_UK]

The COUNTA function will count all cells that have something in them, i.e. both text and numbers.

The COUNT function will only count cells which have numeric values in them.

So, you can use:

=COUNTA(range) - COUNT(range)

Hope this helps.

Pete

[joeu2004]

[.... deleted by me ....]

[joeu2004]

=sumproduct(--istext(d3:d154))

Curious why you say "count ... text" in the title, but you say count "specific words" in the message body.

Those two might not be the same.

By the latter, are you trying to exclude text that is not among the list of "specific words"?