Array-entered, meaning you commit with Ctrl-Shift-Enter

=SUMPRODUCT(--(ISTEXT(A1:A6)))

"Todd Nelson" wrote:

When using the countif formula, how can i have it count the cells that have
any text in them?