PDA

View Full Version : Using Count to get the number of cells in a column that contain text


K4IE
Dec 3, 2008, 03:38 PM
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 & ""))

ScottGem
Dec 3, 2008, 03:42 PM
Try this, in a separate column put the formula:

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

then just sum that column.

JBeaucaire
Dec 3, 2008, 05:10 PM
This is the formula you want:

=COUNTIF(CallSign,"*")

mdosh01
Dec 4, 2008, 06:21 AM
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.

ScottGem
Dec 5, 2008, 01:49 PM
Comments on this post
K4IE (https://www.askmehelpdesk.com/members/k4ie.html) 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/feedback/using-comments-feature-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.