MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count-if Question Re Text


Posted by Michael on December 04, 2001 10:24 AM

I have a column of data that returns either a "0" or some text. What is the countif syntax to count the number of rows that have text? For some reason =countif(a2:a200,">)") works, but there must be a better way.

Thanks


Posted by Mark W. on December 04, 2001 10:43 AM

=COUNTIF(A2:A200,"=*")