I'm trying to just count the number of cells in a column that have text in them. I used a formula given in one of the previous questions and got a return of #NUM.
The fomula I tried was =Sumproduct((Callsign <>"")/Count if (Callsign, Callsign & ""))

Try this, in a separate column put the formula:

=IF(IsText(cell),1,0)

then just sum that column.

This is the formula you want:

Code:

---

=COUNTIF(CallSign,"*")

---

Just to throw in another option, if by "text" you mean cells that are not empty, you can use:

=counta(Callsign)

Assuming "Callsign" is the range in question.

Comments on this post
K4IE disagrees: I may have done something wrong, but it returned a 0. I used another suggestion =countif(callsign, "*" ) and that one worked

First, may I call your attention to the guidelines for using the comments feature found here:

https://www.askmehelpdesk.com/feedba...ure-24951.html

As you note, you may have done something wrong, so why did you give me a negative comment?

I had actually tested this before answering. I've attached a copy of a spreadsheet that shows that it works. In column A, I placed a text a blank and a number. In column B I placed the same formula I gave you in the 3 rows. Only the column containing a text value returned a 1.